Using the Math Operation Action in Workflows
What Is the Math Operation Action?
The Math Operation action allows you to perform automated calculations on numeric, monetary, or date fields directly within your CRM workflows. This versatile feature supports custom variables and integrates seamlessly with If/Else conditions, enabling powerful automation for tasks like lead scoring, financial tracking, and scheduling.
How It Works
To use a Math Operation action, navigate to your workflow builder and add the Math Operation step. You can select a target field (numeric, monetary, or date type) and define the calculation using operators like addition, subtraction, multiplication, or division. Values can be sourced from other fields, custom variables, or static numbers.
Supported Field Types
Numeric Field: Accepts whole numbers or decimals for general calculations.
Monetary Field: Designed for currency values, supporting two decimal places.
Date Field: Allows date arithmetic, such as adding or subtracting days.
Key Considerations
- Negative values can be applied in calculations where appropriate.
- Monetary and numeric fields have constraints on value ranges and precision; results are rounded or truncated based on field type.
- The Current Date field provides a dynamic value representing the present date for real-time calculations.
Common Use Cases
- Lead Scoring: Increment a lead’s score based on interactions.
- Subscription Renewals: Add a subscription period (e.g., 1 year) to a start date.
- Commission Calculations: Multiply sales totals by a commission rate.
- Deadline Tracking: Subtract days from a project start date to set reminders.
- Financial Operations: Calculate taxes, discounts, or interest.
Integrating with Conditions and Other Actions
Math Operation results can be used in If/Else conditions to trigger subsequent workflow steps. For example, you might check if a calculated lead score exceeds a threshold before sending a follow-up email. This action works alongside other workflow actions, such as updating fields, sending notifications, or triggering external integrations.
Frequently Asked Questions
Can I perform multiple math operations in a single step?
No, each Math Operation action handles one calculation. Use multiple sequential actions for complex formulas.
How are rounding errors handled?
Monetary fields round to two decimals; numeric fields truncate or round based on their configuration. Use appropriate field types to minimize precision issues.
Can I use custom date fields?
Yes, date fields—whether system or custom—can be used in date arithmetic.
Are there value range limits?
Yes, numeric and monetary fields enforce minimum and maximum values. Exceeding these limits may result in errors or truncated values.
Can the result be used in an If/Else condition?
Absolutely. The output of a Math Operation can be referenced in conditions to drive workflow logic.
Does it support data from APIs?
Math Operations can use values from custom variables, which may be populated via API integrations, allowing external data to fuel calculations.