Performance Analytics – Formula indicator doesn’t support round() or max()

Med99
Tera Contributor

Hi,

I’m kinda new to Performance Analytics and I'm working on a formula indicator. I’m trying to apply a normalization formula like this:

round(max(-0.000000053 * score^3 + 0.0000411 * score^2 - 0.0109 * score + 1, 0) * 100)

Where score is another indicator.

However, in PA formula indicators:

round() is not recognized

max() is not recognized

So the formula fails with errors like “function not defined”.

Is there a way to use functions like round or max in PA formula indicators?

If not, how do you usually handle this kind of logic? 

Thanks

0 REPLIES 0