Multiplying a mail merge formula

G

Grazza215

Hi guys,

Really hoping someone can help

I've been trying to get this to work, but seem to be missing a trick.

I am using a series of mergefields (linked to a CSV data sheet) and hav
this working fine:

£ { = { mergefield "debits_H"} - { mergefield "EXPCT_AMT2"\#,0.00 } +
mergefield CUR_AG_PAMT }}

This gives me:

Amount 1 - Amount 2 = Amount 3

I need to be able to multiple the above "Amount 3" forumla by 2, 4 an
52/12 (It is a formula for working out rent charges - so a fortnightly
4 weekly, and monthly figure.)

I need to get:

Amount 1 - Amount 2 = Amount 3 * 2

I've tried various incarnations and dont seem to be able to get it righ
- even though I think I've followed all the previous rules.

Has any one got any ideas?

Would really appreciate any help

Thanks

Graham
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top