Formatting currency fields

Question

Hello,We´ve been running some zaps to import certain data from XING events to Hubspot. In our case the XING events API property “OriginalPrice” is €29,00 (amount our customer paid) but the zap delivers 2900 which is x100. That means that the the wrong amount has been imported to Hubspot.  In another case we have an import with 113.050 instead of 1130,50.Do you have a solution how to change or transform the amount in Zapier, e.g. by a formatter?Thx a lot.

william · Accepted Answer

Hey@SPONSORs, I hope you’re doing well, I just wanted to check in here!

Were you able to get things working with the information from Troy, or can we still help out here?

I believe the recommendation for a Formatter - Numbers - Performa Math Operation action would be good here. You may need to use a Formatter - Text - Replace action to remove the comma but once you have the whole number, you can then divid the number by 100 to get the floating decimal value.

For example, say we have 10500,50, we run a replace formatter to remove the comma, so we have: 1050050

From there, we run 1050050 through our Formatter - Number - Perform Math Operation action, divide by 100, and we get: 10500.5

Here’s a screenshot showing what the Perform Math Operation would look like:

Here’s the result:

Troy Tessalone · Answer

Hi @SPONSORsTry using Zapier’s Formatter > Numbers > Perform Math Operation: https://zapier.com/help/doc/how-use-formatter-functionsPerform Math Operation: Add, subtract, multiply, or divide values, or make a number negative (Does not support Line-item fields)

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded