Total Column of Switch Values on a Report

[ggfs]

I am trying to total the amounts produced by the following Switch statement on a report:



=Switch([Days Past Due When Paid]<30,[Amount Paid]*0.02,[Days Past Due When Paid]<60,[Amount Paid]*0.06,[Days Past Due When Paid]<76,[Amount Paid]*0.08,[Days Past Due When Paid]<90,[Amount Paid]*0.12,True,0)

The column is the amount of commission made off of each call a rep makes. The percentage increases after a certain date range is passed. I would like to total how much commission the rep made.

Any suggestions?

[alansidman]

Create a new query with the existing query as the record source. Make the query an aggregate query -- Group on the Rep and Sum on the Commission Field.

Alan

[ggfs]

=Sum(Switch([Days Past Due When Paid]<30,[Amount Paid]*0.02,[Days Past Due When Paid]<60,[Amount Paid]*0.06,[Days Past Due When Paid]<76,[Amount Paid]*0.08,[Days Past Due When Paid]<90,[Amount Paid]*0.12,True,0))

This is was what I put in the Control Source of the Total Box in the Group Footer and it works pefectly! Thank you for your help.