Hi All

At the end of report, I have a section that has Sum of Amount, and I wants to multiple it by 3% if paid by Credit Card.

I knows how to add the verbiage but I cant get the formula to work. Trying to get the formula to say Total amount x 3%. Any ideas?

Thanks in advance everyone!

Hi Josh,

It should be:

Sum({Amount}) * (If {Paid_By} = 'Credit' then 0.03)

Replace fields inside parenthesis with the right database field.

-Abhilash

You already have an active moderator alert for this content.

## Add comment