multiply a field by a figure?

[hansel]

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

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

 

[macropod]

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

 

[hansel]

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%...

 

[Graham Mayor]

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

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Graham Mayor]

Oops - a bracket missing - use:

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

instead.


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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

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.

 

[Graham Mayor]

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.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

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..