word field formula

[dave]

i am attempting to create a field on a word document by adding two mail
merged fields
field 1 - COFA:Cost
field 2 - COFA:Fine
i keep getting a syntax error on just about any way i tried it

exp: =sum(COFA:Fine+COFA:Cost)

 

[Peter Jamieson]

You need a nested field like

{ ={ MERGEFIELD COFA:Cost }+{ MERGEFIELD COFA:Fine} }

where all the {} are the special field code braces you can enter using
ctrl-F9, { MERGEFIELD COFA:Cost } is the mergefield you would use to insert
the COFA:Cost value (it may need double quotes around COFA:Cost, for
example). Use Alt-F9 to see what's there already.

Peter Jamieson