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?
Best answer
How do I stop my Zap from merging decimal values together
Best answer by Troy Tessalone
Hi
Good 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
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
- Answer
Hi
Good 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.