The Calculate widget accepts Excel-style functions and stores the results in a workflow variable. Function parameters can include lookups, and functions can be nested to perform multiple operations.
Step | Action | Result |
1. | Click the button to enter a formula: |
Formula (Required):
|
2. | Select a workflow variable with a Text, Date Time, or Number data type to store the results from the calculation. | Save to Variable (Required) Create variables in the Workflow Settings tab in the settings pane, or click the Create new variable link next to the variable list. |
3. | Click Apply to save the widget settings. | |
Widget in Action:
- Example of the Calculate Widget
- How To Concatenate Two or More Fields
- More Examples of Formulas Used With the Calculate Widget
Return to Workflow Logic Widgets
See Also: