[Graham Mayor]

You are welcome

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Wendy7 wrote:
Thank you for your help. I just found out that the third party
database I'm using translates the field '08APRGP' or
'08AscendTotalRGPAmount' to 'Compute_0017' before merging to Word.
Word dropped the field - and I think that's how the calculation
became - {=*12\#",0.00"} without the mergefield name. I put the
mergefield name as compute_0017 and it works now...

Thank you for your time-
I appreciate it.

Wendy Jones

(Sorry, I was using the '08APRGP' as an abbreviated form of
'08AscendTotalRGPAmount')

"Graham Mayor" wrote:

What do you get when you insert the field you wish to calculate from

{ Mergefield 08AscendTotalRGPAMount }
or is it
{ Mergefield 08APRGP }
that you previously reported?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Wendy7 wrote:
Hi Graham,

I don't know if this helps but when I toggle field codes it returns
the following:

{ = *12\#"$,0.00"}{=*12\#",0.00"}

Thanks

"Graham Mayor" wrote:

You need to insert the field not just its name eg

{={Mergefield 08APRGP} * 12 \# "$,0.00"}

and the field 08APRGP must actually contain a number.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Wendy7 wrote:
Hello,

I'm trying to do a Merge and one of the fields in the merge I need
to multiply by 12. I was using just a simple formula:
{=08APRGP*12 \#"$#,##0.00"}

And I'm getting a syntax error. Does anyone know a solution or
the issue to the formula?

Tank you!
Wendy