Need to calculate on a merge field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Caroline - 16 Mar 2004 22:57 GMT

I'm bringing in records from a medical management
database. I need to be able to calculate and offer a 25%
discount on the amount owed value (which is brought in
from that database). Is it possible to set something
like this up? Thanks for your help.

Word 2000.

Reply to this Message

Charles Kenyon - 16 Mar 2004 23:45 GMT

Use a calculation field:

{ = { MERGEFIELD "AMTOWED" } * .25 }

You may need to use the Round function to keep your amounts to two decimal
places. Field braces {} are inserted using Ctrl-F9 not by ordinary typing.

Signature

Charles Kenyon

See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> I'm bringing in records from a medical management
> database. I need to be able to calculate and offer a 25%
[quoted text clipped - 3 lines]
>
> Word 2000.

Reply to this Message

Graham Mayor - 17 Mar 2004 07:27 GMT

You could use a mask rather than rounding to set a dollar amount eg
{ = { MERGEFIELD "AMTOWED" } * .25 \# ",$0.00 }
See http://www.gmayor.com/formatting_word_fields.htm

Signature

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Use a calculation field:
>
[quoted text clipped - 11 lines]
>>
>> Word 2000.

Reply to this Message

Charles Kenyon - 17 Mar 2004 18:14 GMT

You are right, this will work so long as you are not using the result in
further automatic calculations.

Signature

> You could use a mask rather than rounding to set a dollar amount eg
> { = { MERGEFIELD "AMTOWED" } * .25 \# ",$0.00 }
[quoted text clipped - 14 lines]
> >>
> >> Word 2000.

Reply to this Message

SandyE - 15 May 2004 22:15 GMT

Me again. In Word 2002 and 2003 I was able to use the
result in another automatic calculation by naming the
first result as a book mark (a set field) and then
referencing that field (ref) in a later calculation. ie
{SetTotal { = { MERGEFIELD "AMTOWED" } * .25 }} then
{Ref Total} will bring in the result from amtowed????

>-----Original Message-----
>You are right, this will work so long as you are not using the result in
[quoted text clipped - 19 lines]
>
>.

Reply to this Message