Math in fields using values in Document Properties

[fullcity]

I am trying unsuccessfully to perform math in a field from two values ("hours" and "rate") that I've stored in Document Properties. We manage the values in the Document Properties as we are able to access them using our in house FileMaker solution.

The value in the field now is:

{=({DOCPROPERTY hours}*{DOCPROPERTY rate})}

... Which results in:

!Syntax Error, {

Can someone please assist? What mistake am I making with the syntax?

Thanks,
Adam

 

[macropod]

That suggests you've typed the field braces instead of creating them by Ctrl-F9, for example.

PS: Your field code could be reduced to: {={DOCPROPERTY hours}*{DOCPROPERTY rate}}, though you might also want to add formatting switches to control the output's display. For that, see Mailmerge Number & Currency Formatting in the Mailmerge Tips and Tricks thread at:
http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html
or:
http://windowssecrets.com/forums/showthread.php/163017-Word-Mailmerge-Tips-amp-Tricks

 

[fullcity]

That suggests you've typed the field braces instead of creating them by Ctrl-F9, for example.

PS: Your field code could be reduced to: {={DOCPROPERTY hours}*{DOCPROPERTY rate}}

Thanks, macropod!

Tried what you suggested (CTRL+F9) and then adding what you suggested and I am getting the same error. See the enclosed screengrab.

I'm on a Mac but I've followed your steps.

 

[macropod]

Did you use Cmd-F9 for all three sets of field braces? If so, it seems there is something other than just numbers in your DOCPROPERTY fields.