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
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
Hi Sergey
My understanding is that for Dynamic Calcs there is no order and you can reference them to each other.
Thanks
You're correct. DynamicCalc formulas will just trigger other DynamicCalcs to execute as required, regardless of hierarchy orders. Careful with circular dependencies though!
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 ?
