The Calculate action node enables you to perform mathematical calculations using numeric values.
The versatile node can be used for a variety of purposes, including currency conversion, risk or confidence scoring, calculating compliance percentages, and determining completion rates.
It is worth noting that the Calculate action and the Number value node share the same feature set and can be used interchangeably.
Calculate action node
To use the Calculate action:
- Create an action node and select Calculate from the list of options.
- In the CALCULATOR field, you can reference variables and perform calculations using standard mathematical functions similar to those found in Microsoft Excel. You can refer to the list of available mathematical operations provided below.
If BRYTER identifies any incorrect inputs in this field, a red warning triangle will be displayed. Additionally, after entering a function, a hint is displayed below the input field, providing additional help.
- You can use the result of this calculation in other calculations or reference it in another node to display its value.
It is a good practice to add a short description in the NOTES section of your node. This description will appear below the node name, helping you stay organized and keep track of the calculation performed by the Calculate action.
When working with decimal numbers in a Calculate action, it is crucial to use a period ( . ) as the decimal separator. Commas ( , ) are not accepted for decimal numbers. However, you have the option to customize the number format that is displayed to end users. You can achieve this by toggling on the Custom number format option.
Calculate with collections
For collection fields with numeric values, you can calculate the sum of the elements and determine their average, median, minimum, or maximum by referencing them in the calculator field of a Calculate action. These options mirror those available in a Peform Collection Operation action.
List of mathematical functions
Collapse for a list of most frequently used mathematical functions
ABS: Returns the absolute value of a number. The absolute value of a number is the number without its sign. |
EXP: Returns e raised to the power of a given number |
MAX: Returns the maximum value in a list of arguments |
MEDIAN: Returns the median of the given numbers |
MIN: Returns the minimum value in a list of arguments |
POWER: Returns the result of a number raised to a power |
PRODUCT: Multiplies its arguments |
QUOTIENT: Returns the integer portion of a division |
RANDBETWEEN: Returns a random number between the numbers you specify |
ROUND: Rounds a number to a specified number of digits |
ROUNDDOWN: Rounds a number down, toward zero |
ROUNDUP: Rounds a number up, away from zero |
SQRT: Returns a positive square root |
SQRTPI: Returns the square root of (number * pi) |
SUM: Adds its arguments |
Collapse for a list of all available mathematical functions
ABS: Returns the absolute value of a number |
ACOS: Returns the arccosine of a number |
ACOSH: Returns the inverse hyperbolic cosine of a number |
ACOT: Returns the arccotangent of a number |
ACOTH: Returns the hyperbolic arccotangent of a number |
AGGREGATE: Returns an aggregate in a list or database |
ASIN: Returns the arcsine of a number |
ASINH: Returns the inverse hyperbolic sine of a number |
ATAN: Returns the arctangent of a number |
ATAN2: Returns the arctangent from x- and y-coordinates |
ATANH: Returns the inverse hyperbolic tangent of a number |
CEILING: Rounds up a number to the nearest integer or to the nearest multiple of significance |
COS: Returns the cosine of a number |
COSH: Returns the hyperbolic cosine of a number |
COT: Returns the hyperbolic cosine of a number |
COTH: Returns the cotangent of an angle |
CSC: Returns the cosecant of an angle |
CSCH: Returns the hyperbolic cosecant of an angle |
DEGREES: Converts radians to degrees |
EVEN: Rounds a number up to the nearest even integer |
EXP: Returns e raised to the power of a given number |
FACT: Returns the factorial of a number |
FACTDOUBLE: Returns the double factorial of a number |
FLOOR: Rounds a number down, toward zero |
GCD: Returns the greatest common divisor |
INT: Rounds a number down to the nearest integer |
ISO.CEILING: Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance |
LCM: Returns the least common multiple |
LN: Returns the natural logarithm of a number |
LOG: Returns the logarithm of a number to a specified base |
LOG10: Returns the base-10 logarithm of a number |
MAX: Returns the maximum value in a list of arguments |
MEDIAN: Returns the median of the given numbers |
MIN: Returns the minimum value in a list of arguments |
MOD: Returns the remainder from division |
MROUND: Returns a number rounded to the desired multiple |
MULTINOMIAL: Returns the multinomial of a set of numbers |
ODD: Rounds a number up to the nearest odd integer |
PI: Returns the value of pi |
POWER: Returns the result of a number raised to a power |
PRODUCT: Multiplies its arguments |
QUOTIENT: Returns the integer portion of a division |
RADIANS: Converts degrees to radians |
RAND: Returns a random number between 0 and 1 |
RANDBETWEEN: Returns a random number between the numbers you specify |
ROUND: Rounds a number to a specified number of digits |
ROUNDDOWN: Rounds a number down, toward zero |
ROUNDUP: Rounds a number up, away from zero |
SEC: Returns the secant of an angle |
SECH: Returns the hyperbolic secant of an angle |
SERIESSUM: Returns the sum of a power series based on the formula |
SIGN: Returns the sign of a number |
SIN: Returns the sine of the given angle |
SINH: Returns the hyperbolic sine of a number |
SQRT: Returns a positive square root |
SQRTPI: Returns the square root of (number * pi) |
SUBTOTAL: Returns a subtotal in a list or database |
SUM: Adds its arguments |
SUMPRODUCT: Returns the sum of the products of corresponding array components |
SUMSQ: Returns the sum of the squares of the arguments |
SUMX2MY2: Returns the sum of the difference of squares of corresponding values in two arrays |
SUMX2PY2: Returns the sum of the sum of squares of corresponding values in two arrays |
SUMXMY2: Returns the sum of squares of differences of corresponding values in two arrays |
TAN: Returns the tangent of a number |
TANH: Returns the hyperbolic tangent of a number |
TRUNC: Truncates a number to an integer |
Related topics
- To build risk or confidence scores, calculate compliance percentages, or determine completion rates, you can refer to specific tutorials for both a simple approach and a more complex but flexible approach.