Calling one Dynamic calc account from another dynamic calc account

OS_Pizza
Contributor III

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

4 REPLIES 4

NicolasArgente
Valued Contributor

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

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

Sergey
Contributor III

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 ?

NicolasArgente
Valued Contributor

Hi @Sergey 
My understanding is that for Dynamic Calcs there is no order and you can reference them to each other.
Thanks

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

You're correct. DynamicCalc formulas will just trigger other DynamicCalcs to execute as required, regardless of hierarchy orders. Careful with circular dependencies though!