Performing Calculations using Mail Merge Fields
I'm running into a similar problem, and hopefully you can help. I get a syntax error and do not understand why.
Here is the simple calculation I am trying to do:
Cost / (90% * Rent), formatted with no decimals, where
Cost = $3,000.00
Rent = $247.00
which should yield 13.495276653171390013495276653171 but formatted and displayed as 13.
Here is the Word equation I entered:
{ =({MERGEFIELD Cost}/.9*{ MERGEFIELD Rent})) \# "0"}
Why do I get a syntax error?
|