Skip to main content

Workflow Action: Math Operation

Use the Math Operation workflow action to perform automated calculations on numeric, monetary, and date fields and store the result in another field.

Updated over 3 months ago

Who This Is For / When to Use

This article is for users who need to automate calculations inside workflows, such as adjusting numeric values, updating monetary amounts, or calculating future or past dates.

What the Math Operation Action Does

The Math Operation action applies a single calculation to a supported field and writes the result to another field.

When this action runs:

  • One arithmetic operation is performed

  • The result is written to the selected update field

  • The workflow continues immediately after the calculation

Supported field types:

  • Numeric fields

  • Monetary fields

  • Date fields

Supported Operations

Numeric and Monetary Fields

Supported operators:

  • Add

  • Subtract

  • Multiply

  • Divide

These are commonly used for scores, amounts, counters, and financial values.

Date Fields

Supported operators:

  • Add days, months, or years

  • Subtract days, months, or years

Date calculations are commonly used for follow-ups, renewals, and deadlines.

Important rules:

  • Date fields do not support negative results

  • Calculations must always use positive increments

How to Add the Math Operation Action

Step 1: Create or Open a Workflow

  1. Go to Automations > Workflows.

  2. Create a new workflow or open an existing one.

Step 2: Add the Math Operation Action

  1. Click the + icon in the workflow builder.

  2. Select Math Operation from the action list.

Configure the Math Operation Action

Action Name

Set an internal name for the action to identify it in the workflow.

Example:

  • Update Renewal Date

Select Field (Input Field)

Choose the field that will be used as the input value for the calculation.

You can select:

  • Standard fields

  • Custom fields

  • Trigger-based fields

  • Custom values

Only numeric, monetary, and date fields are available.

Operations

Choose the operator and define the value used in the calculation.

For numeric or monetary fields:

  • Select Add, Subtract, Multiply, or Divide

  • Enter a fixed number or insert a dynamic value

For date fields:

  • Select Add or Subtract

  • Specify days, months, and/or years

Update Field (Output Field)

Select the field where the result will be stored.

Rules:

  • The update field must be the same field type as the selected field

  • The update field can be the same or a different field

Save the Action

Click Save Action to apply the Math Operation configuration.

Field Type Rules and Constraints

Numeric Fields

  • Can store positive or negative values

  • Suitable for scores, counters, and calculations

Monetary Fields

  • Cannot store negative values

  • If a calculation results in a negative number, the value is set to 0

Recommended:

  • Use an If/Else condition after the Math Operation to handle edge cases

Date Fields

  • Do not support negative output values

  • Always calculate using positive increments

Example Use Cases

Example 1: Increment a Numeric Value

  • Select Field: Numeric A

  • Operator: Add

  • Value: 1

  • Update Field: Numeric B

Example 2: Calculate a Renewal Date

  • Select Field: Current Date

  • Operator: Add

  • Years: 1

  • Update Field: Renewal Date

Combining Math Operation With Other Actions

You can combine Math Operation with:

  • If/Else conditions

  • Update Custom Value

  • Add to Workflow

  • Notifications and messages

This allows advanced automation such as thresholds, reminders, and scoring.

Common Issues and Fixes

Math Operation Does Not Run

  • Ensure the workflow is published

  • Confirm the action is reached during execution

Output Value Is Zero

  • Check if the calculation resulted in a negative value

  • Monetary and date fields replace negative results with zero

Update Field Is Not Available

  • Confirm the update field matches the input field type

Frequently Asked Questions

Can I perform multiple calculations in one action?

No. Each Math Operation action performs a single calculation. Use multiple actions for complex logic.

Can I use dynamic values in calculations?

Yes. You can insert trigger values, custom values, or other fields as the operator value.

Can I use the result in an If/Else condition?

Yes. The updated field can be evaluated immediately in subsequent workflow steps.

How are time zones handled for date calculations?

Date calculations use the account’s default time zone and maintain standardized date formatting.

Did this answer your question?