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
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

What you can use in the formula is documented in the page "Examples of Key Functions in Use" in the Design and Reference guide. Apart from the 4 basic operators, you can use FilterMembers, RemoveNoData, RemoveZero, and Add/Subtract/Divide/Multiply/ConvertUnbalanced - plus Eval. I'm not aware of any other function or operator in the mini-language used by Calculate; there are other ones on the language for GetDataCell, but that works at the individual cell level.