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

Marcello's avatar
Marcello
Contributor
3 years ago

api.Data.Calculate available operators (AbsoluteValue)

Hi all except for the standard operators (+,-,*.....) are you aware of a complete list of operators that can be used in "api.Data.Calculate"? I have checked the official documentation with no suc...
Finance
Marcello's avatar
Marcello
Contributor
3 years ago

Hi Henning,

I cannot use a dynamic calc because the issue is on the parent element.

The goal is to have the "abosule value" on the leaf and then rollup the "abosule value" on the parent element (which will display the sum of absolute values instead of the parent amount in absolute value)

 

Are you aware of a list of available operators in the api.Data.Calculate ? Otherwise I think I will have to use a databuffer.

 

Thanks,

Marcello

 

 

Henning's avatar
Henning
Icon for OneStream Employee rankOneStream Employee
3 years ago

There are different approaches possible, e.g. doing this in stage. But to answer your question directly, no, I am not aware of such a function that you can use within an api.data.calculate other than going through the data buffer.