I'm trying to send number data through Zapier, but Zapier does not seem to pick up the 2 decimal places when they are '.00'. In addition, it only picks up one number after the decimal place when the second number is 0.
Here's what I'm doing: form user enters two numbers. My form then:
- Adds these numbers together (SUBTOTAL)
- Multiplies SUBTOTAL by 0.23 (VAT)
- Adds SUBTOTAL to VAT (TOTAL)
On Cognito Forms, all of these numbers display to two decimal places (even when they are '.00'). However, when I send the information through Zapier, Cognito Forms appears to have dropped the 2 decimal places if they are '.00', or dropped one decimal place if it is, for example, '.20'.
I have read the support section on math functions and it looks like Math.Round(Number, Number) might be what I'm looking for, however based on the provided instructions I cannot get that to work.
Does anyone have any advice?