Urgent...Word Mergefield Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wendy7 - 10 Jan 2008 15:30 GMT

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

Reply to this Message

Graham Mayor - 10 Jan 2008 15:37 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Hello,
>
[quoted text clipped - 7 lines]
> Tank you!
> Wendy

Reply to this Message

Wendy7 - 10 Jan 2008 16:07 GMT

Hi Graham -

Thanks for responding - I wasn't inserting another field for the '08APRGP'.
I'm still getting a syntax error however.... I inserted a field for the first
{} then manually typed = then ctrl+f9 again for the 'Mergefield 08APRGP' - my
formula looks like:

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

Do I need to do it from the menu - Insert/Field/MergeField?

Or any other ideas why it's not working? THanks a lot!
Wendy

> You need to insert the field not just its name eg
>
[quoted text clipped - 13 lines]
> > Tank you!
> > Wendy

Reply to this Message

Wendy7 - 10 Jan 2008 16:12 GMT

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

> You need to insert the field not just its name eg
>
[quoted text clipped - 13 lines]
> > Tank you!
> > Wendy

Reply to this Message

Doug Robbins - Word MVP - 11 Jan 2008 01:36 GMT

That certainly looks wrong.

What you should see is something more like what Graham suggested:

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

What do you get if you just have

{Mergefield 08APRGP}

Signature

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

> Hi Graham,
>
[quoted text clipped - 22 lines]
>> > Tank you!
>> > Wendy

Reply to this Message

Graham Mayor - 11 Jan 2008 07:52 GMT

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?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Hi Graham,
>
[quoted text clipped - 30 lines]
>>> Tank you!
>>> Wendy

Reply to this Message

Wendy7 - 14 Jan 2008 15:08 GMT

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')

> What do you get when you insert the field you wish to calculate from
>
[quoted text clipped - 37 lines]
> >>> Tank you!
> >>> Wendy

Reply to this Message

Graham Mayor - 14 Jan 2008 15:15 GMT

You are welcome :)

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Thank you for your help. I just found out that the third party
> database I'm using translates the field '08APRGP' or
[quoted text clipped - 60 lines]
>>>>> Tank you!
>>>>> Wendy

Reply to this Message