Contact Us 1-800-596-4880

Math Operations

You can use this Action Step to perform mathematical calculations. You can enter a formula with fixed values or add values using mapped variables. The result can be reused in the course of the workflow.

The following mathematical operations are available:

  • Addition

  • Subtraction

  • Multiplication

  • Division

  • Absolute value

  • Maximum value

  • Minimum value

  • Exponentiation

  • Round value

Properties

Calculate Expression Result as Here, you can specify whether the result should be calculated and displayed as a whole number (integer) or as a number with decimals (floating point/double-precision floating point).

Math Expression The formula entered is shown here.

Inbound Variables

Math Expression Here, you can enter a formula with fixed values (for example (42+84)/3), or insert variables via Insert Available Variables for use in performing the mathematical operations (for example, ({a}+{b})/{c}).

Outbound Variables

ResultAsFloat The result is displayed as a floating-point value.

ResultAsInt The result is displayed as a whole number (integer).

Wizard

Enter the formula in the Math Expression text field. Clicking Insert Mathematical Operation opens a drop-down list with all available mathematical operations.

Under Insert Available Variables, you will find all variables previously added using the Pin button.

Up to ten variables can be mapped. These are displayed in the Wizard and can be selected for the calculation.

You can enter test values in the Test Values field to test whether or not the formula is valid. Then click the Test button. If the formula is valid, the result will be displayed. Otherwise, an error message will appear. The values of the mapped variables are not important until the production run of the workflow.

If you want to output the result as a floating-point value, select Calculate Expression Result as Floating-Point Value; if you want to display the result as a whole number, select Calculate Expression as Integer Value.

Please note that implied multiplication also applies when you enter the Math Expression and you must put in the parentheses yourself.