Calculation

[Niteshift]

I have a list view of all sales... i want to make a summary box that always shows up and tells me the total sales of all records in the found set... when i do sum(units) i get 1 and when i do Count(units) i get 2... why cant it just add all sales from ALL the records showing??

[-Queue-]

Sum(units) is the total units for the sum field for the current record. What you want is a summary field defined as the total of units, not a calculation field.