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 Tony

Maybe a screenshot is better than explaining in words.

Our goal is to avoid to this

The solution we found in other consolidation system is to have a sys.ERR = abs(err) to put in the validation check.

We were wondering if we could use Math.Abs in the api.calculate but at the moment it seems it cannot be used (unless we use it in a databuffer and set the value cell per cell)

Thanks,

Marcello

 

BSK's avatar
BSK
New Contributor III
2 years ago

Hi Marcello,

We also have a need to calculate absolute values into destination member, Could you please suggest how did you achieve this.

Thanks

  • Marcello's avatar
    Marcello
    Contributor
    2 years ago

    Hi BSK,

    unfortunately I did not manage to find a suitable solution.

    The only way I see is to open a data buffer and loop on values in order to write the "ABS_Element". But I did not develop the rule. 

    KR

    Marcello