Math Functions

Top Previous Topic Next Topic  Print this topic

Math functions perform basic arithmetical operations on input data obtained from various data sources.

 

The following math functions are supported:

const, min, max, sum, subtract, average, multiply, divide, modulus, ceil, floor.

 

Const function inserts a constant value of one of the following primitive types: Boolean, byte, date, double, float, int, long, short, string, uint, ulong, ushort.
Min function compares two or more input values and returns the minimum value between them. To add more input values, right click on the function and select Add Parameter.
Max function compares two or more input values and returns the maximum value between them. To add more input values, right click on the function and select Add Parameter.
Sum function adds two or more input values and returns the sum. To add more input values, right click on the function and select Add Parameter.
Subtract function substracts a number from another number and returns the result of this operation.
Average function calculates the average of two or more input values. To add more input values, right click on the function and select Add Parameter.
Multiply function multiplies two or more input values and returns the result of this operation. To add more input values, right click on the function and select Add Parameter.
Divide function divides two input values and returns the result of this operation.
Modulus function returns the positive value of an input value.
Ceiling function returns the largest previous integer of a real input value.
Floor function returns the smallest following integer of a real input value.