...
Video example of how to work with Mergefield formulas
...
Brief summary of how to use formulas:
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