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
Solved
Store Calculation not working
Hello OneStream experts:
I created and account=MyAccount and put member formula.
api.Data.Calculate("A#MyAccount = A#NETINC")
I set AccountType=Dynamic Calc Formula Type=Formula Pass 1
I am a...
Hi SimpleLove so a DynamicCalc does not store data. It can not be assigned a Formula Pass and you can not use an api.data.Calculate() API call on a DynamicCalc account. You have A#MyAccount as the destination for the calculation. A DynamicCalc should have a Return Statement in which you are returning a value (or text or something). Do you simply want to display the value of the A#NETINC account member?
If you want A#MyAccount to calculate and store a value - change the Account Type = Revenue, and change the Formula Pass to something like Pass 6 - not pass 1 where it may step on Flow member calcs.
Hi SimpleLove so a DynamicCalc does not store data. It can not be assigned a Formula Pass and you can not use an api.data.Calculate() API call on a DynamicCalc account. You have A#MyAccount as the destination for the calculation. A DynamicCalc should have a Return Statement in which you are returning a value (or text or something). Do you simply want to display the value of the A#NETINC account member?
If you want A#MyAccount to calculate and store a value - change the Account Type = Revenue, and change the Formula Pass to something like Pass 6 - not pass 1 where it may step on Flow member calcs.
MikeG Thank you so much for the help. It works now. I have tried to set Account Type = Revenue, but I select formula type= Pass 1 and did not get data. I follow your suggestion and set it to Pass 6 and the calculation did work. It seems the formula type setting is so important. Thanks again.