Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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!

Tags:
Former Member
replied

Hi Josh,

It should be:

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

Replace fields inside parenthesis with the right database field.

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question