I have a list applet that has custom calculations for each column broken in to 3 sections: Actual | Plan |
% of Plan
Actual is calculated as follows: total([Customer Demo] for [Employee Full Name]) - this returns the count of customer demo activies by Rep
Plan is calculated:[Months In Territory]*4 - month in territory is a calculation looking at minimum month in year - maximum month in year and then the plan is 4 activities a month = ex - 6 months in territory * 4 = a plan of 24
% of plan is calculated: (actual/plan)
My issue comes in getting the total Plan. The above list looks like this:
Rep Actual Plan % Plan
Bret1 24 24 100
Bret2 16 24 67
Bret3 18 20 90
The totals should look like this for the above
Total 58 68 85
but I cannot figure out how to get the total plan number to simply add up the values in the plan column.
Any thoughts would be greatly appreciated
this was not so much a totals issue as it was having to explicit name columns in calculations to limit the numbers of rows returned in the query