Apartment Tag - displaying sum total of rooms

[Anonymous]

Hello,

I have an Apartment (Room) Tag, which displays the apartment number, bedroom count, and total area.

I also have individual Room Tags which feed into a Room Area Schedule and are sorted by Apartment number. 

For the Apartment total area, I need to create a Calculated Value which queries the sum total area of all rooms sharing the same apartment number as the room I am tagging. Right now we are manually reading our Room Area Schedule totals and typing it into the Apartment Tag. 

I suppose this is an 'if' statement but not sure about the syntax. Please advise on writing this calculated value formula. Thank you and apologies if the solution is obvious!

Thanks!

Michael 

[barthbradley]

You can get there in a Schedule, but you can't extract that value back into the Room Tag.  

[ToanDN]

There is no built-in solution in Revit.  Workarounds:

- Create Area Plans and use Area Tags

- Use Spaces in lieu of Rooms and Zones for a group of Rooms, then use Zones Tag

- Use Dynamo to collect the Room Area Sum and write it to a shared parameter in the Room Tag

- Format Room Schedule to show only Area Sum for each Apartment, place it on sheet over the Room Tag.

[Anonymous]

Yeah, that we have. Thanks.

[Anonymous]

Ok. Thank you. I did not think it was necessary to work through Dynamo but I will look into it. 

[RDAOU]

@Anonymous 

If you do not want to use Dynamo, AND you do not want to use any Addins...you would then need to use

1. Spaces
2. Zones

=> Add spaces to replace rooms >>> then create a Zone per Apartment (ie: HVAC Zone) >>> add the spaces to the Zone

Tagging the Zone, it can fetch the gross are of the Zones added to it See Below