topic Re: Combine Areas for Two Story Units in Schedule? in Revit Architecture Forum

Combine Areas for Two Story Units in Schedule?

Anonymous — Fri, 18 Aug 2017 21:28:37 GMT

I am new to using the schedule feature. I am trying to figure out how to have it automatically add the two areas from the lower and upper floors of a townhouse unit.

As you can see in the attached image, units 201-206 have an upper and lower area listed. Rather than listing:

201 Lower: 378 SF

201 Upper: 409 SF

I would instead like:

201 (Total): 787 SF

Does anyone know of a solution?

Re: Combine Areas for Two Story Units in Schedule?

amorap — Sat, 19 Aug 2017 06:15:25 GMT

Hi naomiP5XWN

I would do it this way:

1- I would create a new parameter for the room category named for example "duplex" (or can use an existent other like "department" if it is not used yet)
2- Give each room the proper value for this new parameter.
3- Create a new room schedule table. Add the fields you need, and the new parameter "duplex". Be sure that totals are calculated for the field "area" (in "formatting" tab).
4- In sorting/grouping tab, classify by this new parameter "duplex". Allow to show totals in "footer".
5- Make sure to untick "itemize every instance".

That`s all.

regards from Spain.

Re: Combine Areas for Two Story Units in Schedule?

ToanDN — Sat, 19 Aug 2017 22:03:13 GMT

I would use the Unit Number field to indicate only the number, i.e. 201, and add another Unit Level field to indicate the level if applicable. In your schedule, don't include the Unit Level field, sort by Unit Number and for mat it to calculate total, untick itemized every instance, and you will have the sum of the area of a 2-level unit in one row.

Re: Combine Areas for Two Story Units in Schedule?

Anonymous — Mon, 21 Aug 2017 14:14:03 GMT

Great! That did the trick perfectly. To follow up, is there a way to achieve the same result within the area tag on the plans? I have created my own area tags and figured out I could change the area parameter to read as the area plus a value, where the value was the upper area. This let me have the whole unit area listed within the tag on the lower level of each unit, but I have to manually change the value within the tag itself, and would need multiple tags for any variance in areas.

Re: Combine Areas for Two Story Units in Schedule?

ToanDN — Mon, 21 Aug 2017 15:01:03 GMT

@Anonymous wrote:

Great! That did the trick perfectly. To follow up, is there a way to achieve the same result within the area tag on the plans? I have created my own area tags and figured out I could change the area parameter to read as the area plus a value, where the value was the upper area. This let me have the whole unit area listed within the tag on the lower level of each unit, but I have to manually change the value within the tag itself, and would need multiple tags for any variance in areas.

For the tag you would need to add a shared parameter for the upper level's area (Area2) and a Label from a shared parameter for the total area (AreaSum). Enter the formula for the Label (AreaSum) = Area+Area2. Add the same two shared parameters in project and assign them to the Rooms or Areas category, whichever you use. Manually enter the upper level's value for 2-level Units and enter 0 for 1-level Units then you can use a single Tag for all Units.

Re: Combine Areas for Two Story Units in Schedule?

Anonymous — Mon, 21 Aug 2017 19:11:33 GMT

Thank you! I assume that when you say "Manually enter the upper level's value," by value you mean the area. This is by far a better solution than what I had, but unfortunate that it still has to be manually entered.

Re: Combine Areas for Two Story Units in Schedule?

ToanDN — Mon, 21 Aug 2017 20:20:51 GMT

@Anonymous wrote:

Thank you! I assume that when you say "Manually enter the upper level's value," by value you mean the area. This is by far a better solution than what I had, but unfortunate that it still has to be manually entered.

Yes it was what I meant. Unfortunately one Tag can only associate with one host (Room or Area) so you cannot automatically add a value from another Room or Area to it. You could create a Dynamo script to read a value from a parameter of one object and write it to a parameter of another. Visit dynamo forum (link in my signature) and you can find some guidance.

Re: Combine Areas for Two Story Units in Schedule?

Anonymous — Thu, 24 Aug 2017 17:22:14 GMT

I thought I understood how to set up the tag, but when I tried to put it into action I hit a roadblock. I set up a shared parameter (those are new to me) called Area2 and was able to add it to the label formula AreaSum. I then added the Area2 as a parameter, but when I load it into my Revit Project, I cannot get the Area2 parameter to show as an instance parameter. I am able to make it a type parameter, but not all the upper floor areas are the same, so I want to be able to specify on each tag a different Area2.

Re: Combine Areas for Two Story Units in Schedule?

ToanDN — Thu, 24 Aug 2017 17:28:32 GMT

How did you add the Area2 shared parameter in the project? When you do it, check only Room or Area category, nothing else, and you should be able to set it as Instance parameter.

Re: Combine Areas for Two Story Units in Schedule?

ToanDN — Thu, 24 Aug 2017 17:32:36 GMT

Oh, your Area2 in the family is incorrect. It must be a shared parameter, not Family parameter.

Re: Combine Areas for Two Story Units in Schedule?

Anonymous — Thu, 24 Aug 2017 17:37:05 GMT

@ToanDN wrote:
How did you add the Area2 shared parameter in the project? When you do it, check only Room or Area category, nothing else, and you should be able to set it as Instance parameter.

Not sure where you are to be able to see the category list. When I open the Parameter properties (even with Shared parameter selected), I do not have the option to select a category.

Re: Combine Areas for Two Story Units in Schedule?

Anonymous — Thu, 24 Aug 2017 19:01:13 GMT

@ToanDN wrote:
Oh, your Area2 in the family is incorrect. It must be a shared parameter, not Family parameter.

Ah I see now that you were in project parameters, not the family parameters. I found the categories and checked only area, but it still does not show up as an instance parameter for the tag.

Re: Combine Areas for Two Story Units in Schedule?

ToanDN — Thu, 24 Aug 2017 19:42:35 GMT

See screencast for workflow. These steps are important. Revit file is also attached.

Re: Combine Areas for Two Story Units in Schedule?

Anonymous — Thu, 24 Aug 2017 20:42:07 GMT

THANK YOU! Not sure what step I was missing before, but it works perfectly now.

Re: Combine Areas for Two Story Units in Schedule?

joe_aylward — Tue, 17 Jan 2023 10:52:44 GMT

Hi!

I have tried this but I can't make it work out. In fact it doesn't show the sum of the areas but the voice <varies>.

Do you have an idea of what I might do wrong?

Thank you

Re: Combine Areas for Two Story Units in Schedule?

Khaled-CDPartners — Fri, 07 Nov 2025 20:30:52 GMT

You can have a new parameter having the same name, remove the itemize check, and in the formatting, select the area and calculate the totals.