Calculations in a mergefield.
Use
{ IF { {MERGEFIELD CoverageLevel} "" { = ({MERGEFIELD
CI_AR_CoverageLevel}* 2) \# "##" } 0 }
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
wrote in message
oups.com...
sorry was missing a comma in the above merge field. What i'm seeing
after some tinkering is this. I'll enter a formula, it will evaluate
correctly once, and thereafter when i try and view it it will show up
as Syntax Error!. When i try and update, it says it cannot update
one of the fields on the screen, but i can't for the life of me see why
it won't update it. Here's another look at what i've tried:
The following statement below works. But if i try and embed that in
another CTRL-F9, it says it cannot update it:
{ IF { {MERGEFIELD CoverageLevel} "" "{MERGEFIELD
CI_AR_CoverageLevel}" "0" }
This is the statement with the added formula condition. Word says it
cannot update the field.
{ = { IF { {MERGEFIELD CoverageLevel} "" "{MERGEFIELD
CI_AR_CoverageLevel}" "0" } * 2 }
{ = { IF { {MERGEFIELD CoverageLevel} "" "{MERGEFIELD
CI_AR_CoverageLevel}" "0" } * 2 \# "##" }
I've tried it with and without calculations, i'm stumped. Thanks in
advance for any suggestions. What is it about adding the Formula part
that it fails to update?
|