Forum Discussion
No, I do not believe so. By nature, a dynamic account is calc-on-the-fly so the data is not stored; therefore, it cannot roll up to a parent account (which is also agg-on-fly). If you need a dynamic account to roll up, it needs to be a stored formula pass and not dynamic.
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.
- rhankey2 months agoContributor II
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.
- uvrao332 months agoNew Contributor II
Thanks, rhankey :)
Related Content
- 11 months ago
- 2 years ago