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
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Oly wrote:
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