Adding a feild to take a total amount and multiple by a percent

[Former Member]

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!

[abhilash_kumar · Accepted solution]

Hi Josh,

It should be:

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

Replace fields inside parenthesis with the right database field.

-Abhilash