August 7, 200322 yr 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??
August 7, 200322 yr 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.
Create an account or sign in to comment