Math functions

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)

Rounds a number up to the nearest multiple of a specified significance.

ceiling(`Unit Price`, 0.05)

This follows Excel CEILING behavior.

Rounds a number down to the nearest multiple of a specified significance.

floor(`Unit Price`, 0.05)

This follows Excel FLOOR behavior.

Rounds a number to the requested number of digits.

round(Forecast, 2)

This follows Excel ROUND behavior.