Total room area on schedule

[ddragoo144336]

I am required to include a chart (schedule) on each floor plan sheet listing the following information for each room:

Room Number
Room Name
Occupancy Group
Room Area
SF/occupant required by code
Occupant Load

At the bottom of this chart, I need to include the total for Room Area and Occupant Load for that floor. This is where I am having trouble, since I completely cannot figure out how to do this. I can't seem to do anything but just have totals for each instance of a room. Basically, since all the rooms are different and therefore a single instance, it turns out that I just end up with a total under each Room in the Schedule that is the same as the SF for that Room.

We have managed to do an Area Schedule (Gross Building) that just lists area by floor and that is it. I need these totals to show up on my sheets by floor with the individual charts.

I think I made this explanation about as clear as mud, but any help would be fantastic. Thanks!

[dgreen.49364]

Try this. Go to the properties of your schedule. Select Formatting. Click on the field you want, i.e. Area, and check the box marked Calculate Totals. Then go to Sorting/Grouping and check the box called Grand Totals.

[ddragoo144336]

Whooo-hooo!

It was the "Select Formatting. Click on the field you want, i.e. Area, and check the box marked Calculate Totals" part that I wasn't doing. I swear I blew two hours on this on Friday. Thank you so much for your help!