10-10-2023 10:39 AM
A1=100,A2=200 -> Both are Revenue account type and doesnt have any formula.
D1=A1+A2 ->Account type and Formula type -> Both are dynamicCalc
D2->Account type and Formula type -> Both are dynamicCalc
Will the below formula works?
D2=D1+100
10-11-2023 04:04 AM
Hi @OS_Pizza
Yes it should run fine. It is called using Math in Dynamic Calc Formulas like below. As it is a dynamic calc, it will run in memory. nothing stored.
Return api.Data.GetDataCell("(A#Cash + A#AcctsRec) * 1.10")
Find more Dynamic Calc Types with examples, page 34 of the Design and Reference guide.
Cheers
10-11-2023 06:00 AM
Shouldn't it work only if the first dynamic calc account is before the second dynamic calc in the hierarchy ?
Or the order of element in the dimension doesn't matter at all ?
10-11-2023 06:21 AM
Hi @Sergey
My understanding is that for Dynamic Calcs there is no order and you can reference them to each other.
Thanks
10-14-2023 07:02 AM
You're correct. DynamicCalc formulas will just trigger other DynamicCalcs to execute as required, regardless of hierarchy orders. Careful with circular dependencies though!