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().