Get Total Area in Schedule

[donied]

I have a schedule for generic families. The families are square objects. In the scedule I have the area of each square. I have the count of how many squares. I need to get the total area of each type of square.

You would get this by calculating the area by the count. But you cant do that in revit. Any ideas. See attached image

[barthbradley]

Sure you can. Go to Format Tab and select Calculate Totals for the Parameter

...then Sort and Group with Header or Footers and Grand Totals

...I don't even think the Calculated Parameter is needed.  Think you can report the information you want without it.  

[constantin.stroescu · Accepted solution]

cCreate a new Field > Add calculated parameter > create a TotalArea parameter with the same Area value ...the difference is in Formating - the first is No Calculation the second is Calculate Total

[ToanDN]

What @constantin.stroescu suggested is a clever way to have both [Area of each Type] and [Total Area of each Type] in the schedule.  

[donied]

Thank you for your replies. As I wanted to multiply the area by the count to give me total area. I had to create a new parameter called No. as count cant be used in formulas.

Created a calculated value

       Name:No.

       Type: Integer

       Formula: 1

 In Schedule Properties, open the formatting tab.

 Under field formatting, I checked the calculate totals checkbox.

Then multiply this by the area. to give me total area.

Thank you for your help

[ToanDN]

If you had followed his advice you would not need to create the Integer parameter and would still have the Total Area reported correctly.