The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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
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.
CheersHi Sergey
My understanding is that for Dynamic Calcs there is no order and you can reference them to each other.
Thanks- JackLacava
OneStream Employee
You're correct. DynamicCalc formulas will just trigger other DynamicCalcs to execute as required, regardless of hierarchy orders. Careful with circular dependencies though!
- Sergey
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 ?
