Skip to main content
OS_Pizza
Oct 10, 2023 2:39 PM UTC

Calling one Dynamic calc account from another dynamic calc account

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

NicolasArgente
Veteran
Oct 11, 2023 8:04 AM UTC

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

    Employee - Guide
    SergeyEmployee - Guide
    Employee - Guide
    Oct 11, 2023 10:00 AM UTC

    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
    Veteran
    Oct 11, 2023 10:21 AM UTC

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

      Employee - Sage
      JackLacavaEmployee - Sage
      Employee - Sage
      Oct 14, 2023 11:02 AM UTC

      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