Skip to Content
Former Member
Jan 10, 2008 at 03:55 PM

Sum of Avgerage


Post Author: cjsmile2106

CA Forum: Formula

Hello Everyone!!!

I really hope I can get some help here!!! I have a cross-tab report that is broken out by hour of the day (column) then by state (row). My data is the average number of sales. I have no problems with this so far.

My problem is in my report footer I would like to have a sum of the averages by hour. For instance for hour 1300 i have an average of (10 for FL, 5 for GA, and 15 for CO). I want to sum all of the averages together to make a total of 30. I want this for each hour, perferably in a cross-tab. This one has really been kicking my butt! Thank you guys!!