Math functions - cfo.ai Docs

Math functions transform numeric values.

abs

Returns the absolute value of a number.

abs(Actual - Plan)

A negative value becomes positive. A positive value stays positive.

Returns the square root of a number.

sqrt(Variance)

The input must be zero or positive. Use conditional logic if the input can be negative:

if(Variance >= 0, sqrt(Variance), 0)