I am trying to create a discount column in a report that uses information on the amount paid column. If amount paid is $500 or more there is a 3% discount and if amount paid is under $500 there is a 1% discount. I can't seem to figure out how to do this.
Any Help,
Thanks![]()