Statistical functions can be used to calculate key figures of the data that is processed and output with the template.
You can access statistical functions in the Formula Contents dialog box and in the Rule Contents dialog box. Select functions from the Math list in the Operators area of the dialog box.
ceil
Use this function when you want to round up a value to the next bigger integer.
Parameter: parameter
This formula rounds up the sum of the NUMBER_field multiplied by 0.03.
floor
Use this function when you want to round down a value to the next smaller integer.
Parameter: parameter
This formula uses division to transform imperial units to feet and the floor function to round down the result.
min
This function calculates the minimum value of parameters.
Parameters: x, y, z,...
The following formula calculates the lowest number in the series in a report.
max
Use this function to calculate the maximum value of parameters.
Parameters: x, y, z,...
The following formula returns the biggest scale used in drawing views (SCALE1 - 5). As the value is string 1:20 for example, you need to convert the numbers following ":" to integer format before the max comparison.
sqsum
This function calculates the sum of squares.
Parameters: x, y, z,...
The following formula adds the square of 60 plus the square of 70, which prints 8500 in a report.
ave
This function calculates the average of parameters.
Parameters: x, y, z,...
Use the following syntax to calculate the average.
sqave
This function calculates the average of the squared parameters.
Parameters: x, y, z,...
The following formula calculates the sum of squares. The report prints 2646.
