If you need to calculate some data from any app, use Albato Math Operation tool.
It will be useful when:
- You need to convert currency. For example, when the cost comes in dollars, but you want to send it to CRM in euros.
- You receive two or more fields with a numerical value. Then you need to add, subtract, multiply or divide them and transfer into one field. For example, add the weight of the product and the weight of the box to transfer the gross weight. As well as get the deal amount minus the discount amount.
- Add VAT to the amount or perform any other calculations.
Let’s take a look at how to use the tool. For example, you receive two fields in a deal from amoCRM: order amount and discount amount. Then you want to send to Google Sheets the total amount including the discount.
How to set up
Open the Automation builder section and select the tool between steps.
Find the Mathematical Operation tool and click the Select button.
In the Operation field describe the math operation you need. Then select rounding type for fraction results. In the third field, you can write the quantity of characters after zero.
In our example we enter the following values:
amoCRM: Amount — amoCRM: Discount.
Click the Save button.
Click on the settings icon of the next automation step (Google Sheets).
Select the field you need and set the Result parameter from the Albato drop-down list.
Ready! Now you will receive the result of math operation. If Deal Amount is 5000 and Discount Amount is 100, then the math operation result - 4900 - will be sent to Google Sheets.
This is just one of the examples how to use this new tool. You can you it in any automation according to your personal needs.
