Skip to main content
Best answer

Is there a way to calculate the amount in Quickbooks from two values?


Bellevuefineart
Forum|alt.badge.img+1

Zapier instists that “amount” have a value equal to the values of unit price * quantity. How can I do math on these two fields? Normally this field is autogenerated in Quickbooks. 

 

 

 

Best answer by ForYourIT

Hi @Bellevuefineart ,

 

Before you perform the action you show above, you can add a “Formatter by Zapier” action. Then within this, make your mathematical calculation using Numbers → Perform Math Operation.

Then after this calculation, you can use the output of this value in your next step again. Let me know if this helps you!

~Bjorn

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

ForYourIT
Forum|alt.badge.img+7
  • Tinkerer
  • 259 replies
  • Answer
  • May 13, 2020

Hi @Bellevuefineart ,

 

Before you perform the action you show above, you can add a “Formatter by Zapier” action. Then within this, make your mathematical calculation using Numbers → Perform Math Operation.

Then after this calculation, you can use the output of this value in your next step again. Let me know if this helps you!

~Bjorn


Bellevuefineart
Forum|alt.badge.img+1

Thank you very much Bjorn. That worked. 


ForYourIT
Forum|alt.badge.img+7
  • Tinkerer
  • 259 replies
  • May 14, 2020

Great @Bellevuefineart ! Let me know if you need any other assistance.
Please mark this questions as answered. 

~Bjorn