Skip to main content
O
OS_Pizza
October 10, 2023

Calling one Dynamic calc account from another dynamic calc account

  • October 10, 2023
  • 3 replies
  • 0 views

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

3 replies

N
NicolasArgente
October 11, 2023

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

S
Sergey
October 11, 2023

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 ?

N
NicolasArgente
October 11, 2023

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

J
JackLacava
October 14, 2023

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

Terms & ConditionsAccessibility statement