Calculations are quiet advanced and can be tricky to get right.
If there is a value that divides by zero you will get a “REF#” error so ensure that any calculations done are tested before used in the live system.
Calculations
If you want to do any calculation for Merge Fields, follow the following steps:
Open Word document
Press Ctrl and F9 on your keyboard – this will create the expression field { }.
Click inside the expression field and insert your merge field
Right-click on the mail merge field and select ‘Toggle Field Codes’
This will display the merge field nested inside an expression field
From here you can do the calculations on the merge field.
For example, to add 1 to the age field place an equals symbol (=) before the between the two open brackets and plus 1 (+ 1) between the two close brackets.
For example : to display 50% of the total amount in Quote Document { = { Mergefield TotalIncGST} /2 }
Press Alt+F9 to switch to Normal view
Save document and upload