Arithmetic functions

These basic arithmetic functions are available.

Syntax Description
Scalar arithmetic  
@abs(num)
Absolute value
@sqr(num)
Square
@sqrt(num)
Square root
@exp(num)
Exponential
@ceil(num)
Ceiling, least integer not greater than
@floor(num)
Floor, greatest integer not less than
@round(num)
Rounded to the nearest integer
Aggregate arithmetic  
@sum(num1, num2)
Sum
@max(num1, num2)
Maximum
@min(num1, num2)
Minimum
@mode(num1, num2)
Modal value
@stddev(num1, num2)
Standard deviation
@average(num1, num2)
Average

You can use a Value List, Value Group, or Page Group property as an argument to the @SUM(), @MIN(), @MAX() and @AVERAGE().