=CALC
The =CALC() formula can be used to perform mathematical operations on any number or numeric field in your process.
Syntax
Section titled “Syntax”=CALC(MathematicalExpression)Parameters
Section titled “Parameters”-
MathematicalExpression
-
Any valid numeric expression using numbers, numeric fields, or standard mathematical operators (+, -, *, /).
-
Use field tokens (e.g., [[Field: Field Number (Number)]]) to reference numeric fields.
-
How It Works
Section titled “How It Works”-
Evaluates the provided mathematical expression and returns the resulting value.
-
Supports operations such as addition, subtraction, multiplication, and division.
-
The result can overwrite a field or be used in further calculations.
Usage Notes
Section titled “Usage Notes”-
Formula functions are case sensitive and must be entered in all caps.
-
Ensure numeric fields are referenced correctly using field tokens.
-
Parentheses can be used to control the order of operations.
Example
Section titled “Example”=CALC([[Field: Total (Number)]] / 2)If the Total field contains 10, the formula returns 5.
Keywords
Section titled “Keywords”CALC, mathematical formula, numeric calculation, field calculation, process formulas, arithmetic operations, formula function, workflow calculations