Hello!


I have created a doc with a 3 merge fields and need to perform a calculation

{={ MERGEFIELD "MERGE1"\# "€,0"}*(1+.04*{MERGEFIELD "MERGE2"}/{ MERGEFIELD "MERGE3"})}

This returns the correct value to 2 decimal places with the €. How do I round it up to the next whole number please? Or better still round down to the next whole number?

They are all number fields in the SQL database. Merge1 is a €number

In my preview I am getting

!Syntax Error, *

Cheers in advance

Solved this myself after reading through the very useful Maths Tutorial!
Cheers!