I am writing a report that lists records like this:
Date Company Reveue Commish(5%) Run Tot
12/1/04 A 10,000 500 500
12/2/04 A 20,000 1,000 1,500
12/3/04 A 16,000 800 2,300
12/4/04 A 12,000 600 2,900
I want to cap the amount of commishion paid at 2,000. I would like for report to look like this:
Date Company Reveue Commish(5%) Run Tot
12/1/04 A 10,000 500 500
12/2/04 A 20,000 1,000 1,500
12/3/04 A 16,000 300 2,000
12/4/04 A 12,000 0 0
Not sure if this is possible, I have been attempting it all morning.... any advice would be great.
Date Company Reveue Commish(5%) Run Tot
12/1/04 A 10,000 500 500
12/2/04 A 20,000 1,000 1,500
12/3/04 A 16,000 800 2,300
12/4/04 A 12,000 600 2,900
I want to cap the amount of commishion paid at 2,000. I would like for report to look like this:
Date Company Reveue Commish(5%) Run Tot
12/1/04 A 10,000 500 500
12/2/04 A 20,000 1,000 1,500
12/3/04 A 16,000 300 2,000
12/4/04 A 12,000 0 0
Not sure if this is possible, I have been attempting it all morning.... any advice would be great.