SOLVED - Problems with totals

[bpothier]

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

[bpothier]

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