Hi there,



I've managed to do some simple maths e.g. Performing a single operation on a mail merge field, and adding two mail merge fields together.

I now need to add two fields together and then multiply that total by 1.2, to give a gross (post tax) total.

I've had a look at the Field Maths tutorial, but I'm still struggling to get my head around whether there's a syntax to get it to do what I want all at once.

Predictably, if I try...

{ ={ MERGEFIELD FIELD1}+{MERGEFIELD FIELD2} * 1.2}

...it of course only does the multiplication on FIELD2.

Is there a way of getting it to do everything I want in a single line? By positioning the brackets differently?

Or, as there are three operations, would I need to do something like use different variables to hold the results of FIELD1 * 1.2 and FIELD2 * 1.2 and then add those two variables together?

If so, could you give me a pointer on the code for that?

Changing the data at source would mean dev work, so if it's possible to do this within Word it would be much better.

Thanks,

Andy.T

I haven't tried it but logically it should be:
{ =({ MERGEFIELD FIELD1}+{MERGEFIELD FIELD2}) * 1.2}

Ahah! That works perfectly, that's brilliant, thanks so much.

I'm a complete novice so I was thinking the solution would involve more curly brackets, I hadn't thought one could use standard brackets.

If you have another look at the Field Maths tutorial you will see several examples showing the use of brackets.

This is simply using the parentheses to dictate the order of operations.

Yep, I didn't know one could use regular brackets, but Italophile set me straight, so I'm all set.

I'm completely new to this, never done anything like this before. Thanks for your reply.