Calculating a negative number

[bellevue]

I have a field on my form that calculates the card charges for each payment a customer makes (the control source is below):



=IIf([Method]="Card",(([Amount]/100*3.4)+0.2),0)

On this basis of a payment of £50.00 would return a value of £1.90 for card charges and that's all good.

However, if I refund that £50.00 payment to the customer and enter "-£50.00" in the Amount field, the card charges show up as "-£1.50" which obviously isn't right.

I understand why it's doing this but wonder if someone could tell me what I need to do to make sure the card charges (for refunds (negative amounts)) comes up with the correct amount please ?

Thanks

[orange]

I think you'll have to tell us how Card charges relate to Refunds.
You have said that if Method = Card....., but we know nothing of your set up for Refunds.

[jzwp11]

Perhaps something like this:


=IIf([Method]="Card",IIF([Amount]<0, -1*((ABS([Amount])/100*3.4)+0.2),(([Amount]/100*3.4)+0.2)),0)

[bellevue]

Thanks so much jzwp11, you're a star, that's cracked it !

Best wishes

[jzwp11]

You're welcome