The Math Operation action in workflows allows users to perform calculations on numbers and dates, enabling automated lead scoring and scheduling. This feature supports custom variables and fields, offering flexibility for different business needs and seamless integration with If/Else conditions for lead management.

What is the Math Operation Action in Workflows?

The Math Operation action in workflows is a powerful tool that automates calculations and manipulations on numeric and date fields, streamlining business processes and decision-making. For example, imagine a gym that wants to automatically update its members' renewal dates by adding one year to its current membership expiration date. With the Math Operation action, the gym can effortlessly set up a workflow to perform this calculation, saving time and ensuring accuracy while focusing on providing excellent service to its members.

Some Excellent Usage Cases for the Math Operation and How it Solves Some Real Business Problems:

  • Gym Membership Renewal: Automatically update membership renewal dates by adding one year to the current expiration date, ensuring timely reminders for clients and improved retention.
  • Loan Amortization: Calculate the remaining balance of a loan after each payment, helping businesses keep track of their financial health.
  • Sales Commissions: Calculate commission amounts for sales representatives based on custom commission rates and achieved sales targets, ensuring fair and accurate compensation.
  • Lead Scoring: Increment lead scores each time a lead interacts with a business, such as making a phone call or visiting the website, to gauge their interest and prioritize follow-up efforts.
  • Project Deadlines: Add or subtract days from project start dates to calculate deadlines and automate reminder notifications for team members.
  • Subscription Expirations: Calculate subscription expiration dates for a software service by adding the subscription duration to the activation date, enabling timely renewal reminders.
  • Customer Lifetime Value: Multiply average purchase value by the frequency of purchases to estimate a customer's lifetime value, helping businesses identify high-value clients and optimize marketing efforts.
  • Inventory Management: Subtract sold items from the total inventory to track stock levels and automate reordering processes.
  • Warranty Tracking: Add warranty duration to the product purchase date to determine the end of warranty coverage and facilitate customer support.
  • Age Verification: Subtract a customer's birthdate from the current date to verify their age for age-restricted products or services.
  • Discounted Pricing: Multiply the original price by a discount percentage to calculate discounted prices during promotional campaigns.
  • Sales Tax Calculation: Multiply the subtotal by the applicable tax rate to determine the final price, ensuring accurate invoicing.
  • Employee Performance Metrics: Calculate performance metrics, such as sales quotas or customer satisfaction scores, to evaluate employee performance and identify areas for improvement.
  • Rental Property Management: Calculate late fees for overdue rent by multiplying the daily late fee rate by the days past due, encouraging timely payments.
  • Milestone Bonuses: Calculate milestone bonuses for employees by multiplying their base salary by a predetermined bonus percentage, rewarding hard work and dedication.
  • Product Profit Margin: Subtract the cost of goods sold from the selling price and divide by the selling price to calculate profit margins, enabling informed pricing decisions.
  • Customer Segmentation: Calculate the average time between purchases to segment customers into groups like "frequent buyers" or "occasional shoppers," optimizing marketing campaigns.
  • Event Countdown: Subtract the current date from the event date to display a countdown timer for upcoming events or promotions.
  • Budget Tracking: Subtract expenses from the total budget to monitor remaining funds and ensure responsible spending.
  • Interest Calculation: Calculate interest on savings accounts or loans by multiplying the principal balance by the interest rate, providing a clear overview of financial growth or debt repayment.

Benefits of the Math Function:

The benefits of the Math Operation feature in workflows include:

  • Automation: Streamline repetitive and time-consuming calculations, freeing time for more valuable tasks and improving overall productivity.
  • Accuracy: Minimize human error in calculations, ensuring precise results and reliable data for decision-making.
  • Customization: Perform mathematical operations using custom fields and variables, tailoring calculations to suit specific business needs and scenarios.
  • Improved Decision-Making: Gain valuable insights from data analysis, enabling better-informed strategic decisions and optimizing business performance.
  • Enhanced Lead Management: Use calculated lead scores and other metrics in If/Else conditions to route leads through sales funnels more effectively, improving conversion rates and sales outcomes.
  • Time-based Scheduling: Automate time-sensitive processes and task scheduling using date-based calculations, ensuring timely reminders and follow-ups.
  • Flexibility: Perform various calculations, including addition, subtraction, multiplication, and division, on both numeric and date fields, accommodating diverse business requirements.
  • Integration: Seamlessly integrate with other workflow actions and conditions, such as If/Else, to create more dynamic and robust business processes.
  • Scalability: Efficiently handle growing volumes of data and calculations as a business expands without manual intervention or additional resources.
  • Cost Savings: Reduce manual labor costs associated with performing calculations and maintaining data accuracy, ultimately improving the bottom line.

How Does It Work?

The Math Operation feature in workflows works by following these steps:

  1. Create or Select a Workflow: Begin by creating a new workflow or selecting an existing one where you want to apply the Math Operation action.

  2. Add the Math Operation Action: In the workflow builder, click "Add Action" and select the "Math Operation" action from the list of available actions.

  3. Choose the Field to Update: Select the numeric or date field you want to update with the result of the math operation. Depending on your requirements, this field can be a standard or custom field.

  4. Select the Operation: Choose the mathematical operation you want to perform on the selected field.

    • You can choose from addition, subtraction, multiplication, or division for numeric fields.
- And you can choose the addition or subtraction of days, months, or years for date fields.

  2. You Can Add Any Values from the Trigger and Use Them in the Field "Select Field" The numeric and trigger fields will also be available in the 'Value" field in the operation section.

  3. Input the Operator: Enter the value or custom field to use as the operator in the math operation. For example, if you want to add 10 to a numeric field, input "10". If you use a custom field, you can insert it using the appropriate merge tags or custom field syntax.

  4. Update Field: Select the field that you would want to update. In the Update field dropdown, you will find "Standard Fields," "Custom Fields," and "Custom Values" to select from.

  5. Save the Action: Click "Save" to apply the Math Operation action to the workflow.

  6. Activate the Workflow: Once you have configured the Math Operation action and any other required actions and conditions, Publish the workflow. The math operation will execute automatically whenever the workflow is triggered, updating the specified field according to the configured operation.

  7. Combine with Other Actions and Conditions: Optionally, you can integrate the Math Operation action with other actions, such as sending emails or updating fields, and conditions, like If/Else, to create more complex workflows tailored to your business needs. Read Five Usage cases for that below:

Five Usage Cases for Combining Math Operations with Other Actions and Conditions:

  • Lead Prioritization and Follow-Up: Use the Math Operation action to increment a lead's score based on their interactions with your business. Combine this with If/Else conditions to segment leads into different categories (e.g., hot, warm, and cold leads). Trigger different follow-up actions, such as sending targeted email campaigns or assigning high-priority leads to sales representatives for immediate contact.
  • Subscription Renewal Reminders: Use the Math Operation action to calculate the renewal date of a subscription by adding the subscription duration to the start date. Combine this with an If/Else condition to check if the renewal date is approaching (e.g., within the next two weeks). If true, trigger reminder emails to encourage customers to renew their subscriptions.
  • Sales Commission Calculation and Notification: Utilize the Math Operation action to calculate sales commissions for your sales team based on their performance metrics (e.g., revenue generated or deals closed). Combine this with an If/Else condition to check if the commission amount exceeds a certain threshold, indicating exceptional performance. If valid, email the sales representative congratulating them on their achievements and informing them of their commission payout.
  • Project Deadline Tracking: Use the Math Operation action to calculate project deadlines by adding the project duration to the start date. Combine this with If/Else conditions to check if the deadline is approaching (e.g., within the next week) or the project is overdue. Depending on the outcome, trigger actions such as sending reminder emails to the project team or escalating the issue to a manager for intervention.
  • Customer Loyalty Program: Implement the Math Operation action to update customers' loyalty points based on their purchases or interactions with your business. Combine this with If/Else conditions to check if the customer has reached a specific points threshold, making them eligible for rewards or special offers. If the condition is met, send an email notifying the customer of their reward and encouraging them to redeem it.

Short Summary:

  • Select Field: Select any Numeric / Monetary / Date field as an Input.
  • Operations: Select an operation and enter respective values.
  • Update Field: Choose any field to update it with the output value.

Please Note:

  • Only Numeric, Monetary, and Date field types are supported.
  • The Select field and Update Field can be the same or different, but it has to be of the same field type.
  • If the output value is negative, then it will be replaced with zero.

Numeric / Monetary Field Types

Numeric and monetary fields are two types of custom fields in workflows that are designed to store numerical values. They can hold and manipulate quantitative data within a workflow, such as lead scores, sales figures, or financial data. Here are some details about these field types:

Numeric Field:

  • Purpose: Numeric fields are designed to store whole numbers or decimal values, such as counts, quantities, percentages, or ratios.
  • Data Format: Numeric fields can accept both positive and negative values and decimal values with varying precision, depending on the system's configuration.
  • Use Cases: Numeric fields can store data like lead scores, product quantities, customer satisfaction ratings, or conversion rates.

Monetary Field:

  • Purpose: Monetary fields are designed to store currency values, representing financial data such as prices, costs, revenues, or commissions.
  • Data Format: Monetary fields store numeric values with a designated currency symbol (e.g., USD, EUR, GBP) and typically have a fixed precision to represent cents or smaller units of the currency. They ca