Attached to the ticket is an image showing a figure taken from a new Square payment.
The amount should be 327.29; however, it is displaying the amount without the comma.
Is there a way to fix this?
Best answer
Unable to display issues with Square payment amounts in Zapier
- Beginner
- 4 replies
Best answer by Troy Tessalone
For us to have more info, post screenshots with how your Zap Formatter step is configured.
e.g. 123 / 100 = 1.23
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
- 34072 replies
Hi
Many financial apps return amounts in the lowest denominator: cents
You can use a Formatter step to divide by 100 to get the amount in: dollars
Zap action: Formatter > Numbers > Perform Math Operation (Divide)
- Beginner
- 4 replies
I’ve tried converting it to currency and adding .00 or 2 decimal places, but it doesn’t understand what needs to be done. In this case, Perform Math Operation (Divide) doesn’t work for what I need, which is to add the decimals after the comma or period. With Format Currency, it almost works, but there’s no option to specify how many decimal places we want to set based on the given number.
+14- Zapier Orchestrator & Solution Partner
- 34072 replies
- Answer
For us to have more info, post screenshots with how your Zap Formatter step is configured.
e.g. 123 / 100 = 1.23
- Beginner
- 4 replies
Thank you for the support. I was able to resolve this issue, and hopefully this solution will work for each payment received.
+6- Zapier Staff
- 3527 replies
Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.