How to Divide 2 values on an Invoice PDF

[Rajkumar]

Question:

I want to create a field on the invoice template that divide 2 amount from other fields on the invoice that is pulled from the system.

so if one field have value 1000
another field have value 2
then the value in my field would be (value 1 / value 2) = 500

Solution:

All kinds of calculations are based out on MS Word features and not a Zuora provided one. Below are the some of the articles which covers the Division calculation using Mail Merge functionality.

• https://www.msofficeforums.com/mail-merge/22826-mail-merge-field-trying-divide-time-however.html

• http://www.wordbanter.com/showthread.php?t=44681&__cf_chl_captcha_tk__=4e1c01b8b325b3940c257a2e12f52...

• https://www.office-forums.com/threads/division-calculations-in-mergefields.1790794/ 

Sample Testing from Local tenant:

Invoice Detail

Template Setup: Divided Extended Price with Unit Price

Invoice PDF