on 10-23-2015 8:18 PM
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.