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