Mailmerge calculations syntax

[Oly]

Hi there

I'm currently looking at doing some mailmerge calculations. I want to get
some examples of some of the syntax involved, for instance, division,
multiplication, and formatting the results properly on screen. Here's an
example:-

{={ MERGEFIELD CourseBookingCostByStatus_SumTuitionCost \* MERGEFORMAT} /
{MERGEFIELD CourseBooking_NumberofStudents } \# "£#,##0.00 } }

For instance, i'm trying to get word to divide the total cost of a training
course by the number of students enrolled - yet when the calcuation is
performed, it shows {= 32456.4300 / 3}, instead of the actual result.

Can someone help? Just think i need some syntax examples to follow..

many thanks

Ol

 

[Graham Mayor]

You have to insert all the field boundaries with CTRL+F9. The syntax then is

{=({ MERGEFIELD CourseBookingCostByStatus_SumTuitionCost} / {MERGEFIELD
CourseBooking_NumberofStudents }) \# "£,0.00 } }

Note too that your data fieldnames are excessively long which will lead to
errors. Restrict fieldnames to 10 characters if possible.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>