The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
DynamicCalc Account roll-up
Hi All,
Is there any option/setting for DynamicCalc account data rolled up to its parent (account type is expense)
Hi T_Kress, thanks for prompt response, actually I wrote member formula and not getting correct output. When I change account type and calculation as Dynamic then retrieving correct output. below is the formula
Account_OP = (Acct1+ Acct2)/ (Act1+Act2+Act3+act4) * Acct5, I observed that division not working. I seen diff between manual division and system division but whereas using Dynamic property then the system calculated correct value.
Is there any syntax for getting correct result of division.
Formulas with division almost always have to be computed as dynamic calcs, so they occur after any dimension aggregation. Performing division as a stored calc will be correct with base level data, but will usually not provide the desired results as you aggregate up the hierarchy.
Thanks, rhankey :)