Skip to main content

Hi, 

I’m trying to divide the input field value by 1.1 to calculate the amount excluding GST (10%).
Here’s my set up. Couldn’t figure out why it doesn’t work. Any help is much appreciated.

 

 

Hey ​@ASAoperations,

To get your desired result to divide by 1.1, you have to put the stripe amount in first input and 1.1 in the second input. Now coming to the error, you are probably getting it because the field you are sending from Stripe is not in a number format. You can use another Formatter Number action to convert that a field to a number which you can dynamically pass to the Formatter divide action. Hope it helps!


Hi ​@ASAoperations 

An alternative approach would be to use this Zap action: Formatter > Numbers > Perform Math Operation

 

Formula Functions: 

https://help.zapier.com/hc/en-us/articles/8496181204877-Available-spreadsheet-style-formulas#formula-functions-0-0