multiply a field by a figure?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hansel - 27 Aug 2004 21:50 GMT

Would like to multiply a field by a percentage, possible?

Also, can I total fields across recoreds and display in
another?

Reply to this Message

macropod - 27 Aug 2004 23:18 GMT

Hi hansel,

You certainly can, and it's fairly straight-forward.

For more details, see:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=365442
(url all one line)

Cheers

> Would like to multiply a field by a percentage, possible?
>
> Also, can I total fields across recoreds and display in
> another?

Reply to this Message

hansel - 28 Aug 2004 02:39 GMT

Am I missing something? I downloaded your file and
couldn't seem to figure it.. Maybe you could provide some
assistance?

One field has a numeric value.
Say 10,000

Would like to multiply that by a few percentages and have
displayed in other fields..

i.e, 8%, 12.5%, 15%...

>-----Original Message-----
>Hi hansel,
[quoted text clipped - 18 lines]
>
>.

Reply to this Message

Graham Mayor - 28 Aug 2004 07:19 GMT

Multiply the merge field by the decimal value of the percentage in a formula
field

{=({Mergefield fieldname} * .08}
{=({Mergefield fieldname} * .125}
{=({Mergefield fieldname} * .15}

Signature

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

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

> Am I missing something? I downloaded your file and
> couldn't seem to figure it.. Maybe you could provide some
[quoted text clipped - 30 lines]
>>
>> .

Reply to this Message

Graham Mayor - 28 Aug 2004 12:22 GMT

Oops - a bracket missing - use:

{=({Mergefield fieldname} * .08)}
{=({Mergefield fieldname} * .125)}
{=({Mergefield fieldname} * .15)}

instead.

Signature

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

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

> Multiply the merge field by the decimal value of the percentage in a
> formula field
[quoted text clipped - 37 lines]
>>>
>>> .

Reply to this Message

- 28 Aug 2004 17:24 GMT

That's great, thanks, took a few times to get it right, a
little difficult in that Word, as I'd change the focus to
IE to read your syntax would kick it out as not valid
until completed..

What about adding the '$' symbol to the result?

And also what about totalling selectred mergefield figures
across all records, and displaying..

Thanks very much.

>-----Original Message-----
>Oops - a bracket missing - use:
[quoted text clipped - 48 lines]
>
>.

Reply to this Message

Graham Mayor - 28 Aug 2004 17:50 GMT

To add the $ symbol you need a field switch -

{=({Mergefield fieldname} * .15)\# ",$0.00"}

Totalling could be problematical. We need more information about your merge.

Signature

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

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

> That's great, thanks, took a few times to get it right, a
> little difficult in that Word, as I'd change the focus to
[quoted text clipped - 69 lines]
>>
>> .

Reply to this Message

- 28 Aug 2004 18:16 GMT

I was just about to post and say that I just entered
the '$' before the syntax :)..

Yes, totalling..

Maybe it would be easier, I see it as this..

There are two types of 'lines' of data:

One has the mergefield
The others contain this syntax

I'm guessing it's difficult to total the syntax lines, so
what about just taking the original figure/mergefield and
running another formula on it?

Total all mergefields (unique) across records and display..

In the right direction? Are you already there?

-------------

Then one other, your previous syntax.. What's the
structure to then multiply by 12 (to obtain yearly
figure)..

Thanks much..

>-----Original Message-----
>To add the $ symbol you need a field switch -
[quoted text clipped - 78 lines]
>
>.

Reply to this Message