Skip to Content
avatar image
Former Member

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 24, 2015 at 03:30 AM

    Hi Josh,

    It should be:

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

    Replace fields inside parenthesis with the right database field.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded