How do I stop my Zap from merging decimal values together

Question

I want to fetch the payment captured data from razorpay to google sheet. But the zap is merging the decimal values together. If the paid amount is 250.00 it is taking the decimal numbers together as 25000. how to correct this issue. Any solution for this?

Troy Tessalone · Accepted Answer

Hi @HamidGood question.Many payment apps show amounts in the lowest denominator (cents).You can add a Zap step to divide by 100.Try Formatter > Numbers > Perform Math Operation

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded