Dear Group:
For some reason, I am having a very hard time with how to get the totals for a calculated column and display it in the Totals Row.
I am trying to build an SSRS report that has a column based on a percentage:
AgentSales AgentCommission Commission
20 .25 5 (20 * .25)
33 .12 3.96 (33 * .12)
46 .76 34.96 (46 * .76)
Totals: 99 [Unknown Calculation]
However, where I am having problems is I need to get what would be the totals column? How would I calculate the Commission so that the number shown in [Unknown Calculation] to display what I assume would be the average commission?
- This topic was modified 4 years, 4 months ago by AMCiti.