# Collect Room Area by Parameter name

**URL:** <https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941>\
**Category:** Revit\
**Tags:** revit, dynamo\
**Created:** [November 3, 2021, 8:54am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941 "2021-11-03T08:54:27Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 3, 2021, 8:54am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/1 "2021-11-03T08:54:27Z")

</div>

Hi,

very new to Dynamo. I’m stuck and need some assistance. I’m working on a appartment building. Every appartment has it’s own unique designation (“Bouwnummer”).  
I want to add up the room area’s per appartment by using “Bouwnummer” ( every room in a unique appartment has the same "Bouwnummer"value) and return that value back into a Revit schedule ( and name it Collected Area or something like that) so that I can use that collected value for other calculations in a schedule.  
I have allready have some work done but I don’t know how to finish it.  
I wanted to ad the file but as a newbie I’m not allowed to!. Any comments and or pointers are appreciated.

I have used "_All elements of category"_ and _“parameter.parameterbyname”_ to make a list of rooms with the same “Bouwnummer”. I also have all the area values of every single room. Somehow I have to combine these two but I can’t figure out how.

“Please help me Obi-Wan Kenobi. You’re my only hope”

Thnx

ps. Tip from another user: I have added a WeTransfer link with the .dyn file

> **[Room\_Area\_by\_Department.dyn](https://wetransfer.com/downloads/2a9ee48a0f296fcca4a76cc1bbf49c6b20211103104829/482ad2)**
>
> 1 file sent via WeTransfer, the simplest way to send your files around the world

---

<div class="post-metadata">

**Author:** ![Marcel\_Rijsmus](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/marcel_rijsmus/32/8539_2.png) [@Marcel\_Rijsmus](https://forum.dynamobim.com/u/Marcel_Rijsmus)\
**Post date:** [November 3, 2021, 10:22am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/2 "2021-11-03T10:22:20Z")

</div>

You can share your files via WeTransfer  
Upload the link you receive if you wetransfer it to yourself.

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 3, 2021, 10:50am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/3 "2021-11-03T10:50:14Z")

</div>

Dank je. Heb ik net gedaan

---

<div class="post-metadata">

**Author:** ![\_Vijay](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/_vijay/32/91307_2.png) [@\_Vijay](https://forum.dynamobim.com/u/_Vijay)\
**Post date:** [November 3, 2021, 11:29am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/4 "2021-11-03T11:29:31Z")

</div>

![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/2/1217fbcdc7a9bd463ce8b2b77dbd07ac1ded5ae4.png)

[Room\_Area\_by\_Department.dyn](https://forum.dynamobim.com/uploads/short-url/22cirUcRpL7XeBC2yZRBdLUVDZj.dyn) (6.1 KB)

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 3, 2021, 12:54pm UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/5 "2021-11-03T12:54:51Z")

</div>

thnx for the feedback! But it’s not what I mean. I need to add up all the room area’s with the same “Bouwnummer” into 1 single value per “Bouwnummer”.

see image. I need to add up the area’s of all “Bouwnummers” with the same number. e.g. 001

 ![Schermafbeelding 2021-11-03 135053](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/9/291f49889083c9844e8747f0f9ab95124a6d395e.jpeg)

---

<div class="post-metadata">

**Author:** ![\_Vijay](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/_vijay/32/91307_2.png) [@\_Vijay](https://forum.dynamobim.com/u/_Vijay)\
**Post date:** [November 3, 2021, 12:56pm UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/6 "2021-11-03T12:56:23Z")

</div>

what is that mean “Bouwnummers” ?

group and sum the values.

---

<div class="post-metadata">

**Author:** ![Marcel\_Rijsmus](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/marcel_rijsmus/32/8539_2.png) [@Marcel\_Rijsmus](https://forum.dynamobim.com/u/Marcel_Rijsmus)\
**Post date:** [November 3, 2021, 1:01pm UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/7 "2021-11-03T13:01:08Z")

</div>

List.GroupByKey should work here

---

<div class="post-metadata">

**Author:** ![\_Vijay](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/_vijay/32/91307_2.png) [@\_Vijay](https://forum.dynamobim.com/u/_Vijay)\
**Post date:** [November 3, 2021, 1:15pm UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/8 "2021-11-03T13:15:54Z")

</div>

[Room\_Area\_by\_Department (1).dyn](https://forum.dynamobim.com/uploads/short-url/kyS3bCRTOPbvVLVwWcebhAsBxU5.dyn) (15.6 KB)

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/d/fdbc7992be30fa47d12eaf06ea91b54874031d7a.png)

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 3, 2021, 3:01pm UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/9 "2021-11-03T15:01:04Z")

</div>

Bouwnummers is a parameter that I added. It is Dutch for: building number. It is used to designate an appartement or house during the build, before they get assigned a final housenumber

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 3, 2021, 3:02pm UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/10 "2021-11-03T15:02:09Z")

</div>

And I’m so new to Dynamo that I don’t know how to group and sum but I get your point.

Thnx for your patience

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 3, 2021, 3:02pm UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/11 "2021-11-03T15:02:54Z")

</div>

I’ll try that

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 3, 2021, 3:52pm UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/12 "2021-11-03T15:52:30Z")

</div>

Thnx! Now at least I have the sum of all the rooms per appartment!

most gratefull

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 4, 2021, 7:41am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/13 "2021-11-04T07:41:15Z")

</div>

Goodmorning,

so I ran your script and it works. I now have all rooms belonging to a certain “Bouwnummer” added up . They are listed with random numbers. So I have no idea which summarized room area belongs to which “Bouwnummer”. Is there a way to have the Bouwnummers in the list instead off just numbers ( 0,1,2,3,4,5,etc…)?

 ![Room_Area_by_department](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/d/1d6cbd2103bd39eebf500fab840263aff562d130.jpeg)

---

<div class="post-metadata">

**Author:** ![\_Vijay](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/_vijay/32/91307_2.png) [@\_Vijay](https://forum.dynamobim.com/u/_Vijay)\
**Post date:** [November 4, 2021, 9:20am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/14 "2021-11-04T09:20:28Z")

</div>

Yes you can sort and group 1st…then make sum

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 4, 2021, 10:12am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/15 "2021-11-04T10:12:27Z")

</div>

👍

---

<div class="post-metadata">

**Author:** ![bvs1982](https://avatars.discourse-cdn.com/v4/letter/b/43a26b/32.png) [@bvs1982](https://forum.dynamobim.com/u/bvs1982)\
**Post date:** [November 4, 2021, 10:33am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/16 "2021-11-04T10:33:40Z")

</div>

Out of curiousity; why don’t you use the Schedule to make the sums?

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 4, 2021, 10:38am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/17 "2021-11-04T10:38:53Z")

</div>

Hi,

offcourse a very legit question. I did that first. And It shows up nicely in the schedule. The problem is that I need the calculated value of all the rooms per house/ appartment because I need to do other calculations with that area. ( e.g. The number off bike parking spaces I need to have per house based on the total area per house). I usually do it manually by making an areaplan and use that area. But by using the room area’s it’s much faster and with this Dynamo script I can use it over and over again in other projects.

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 4, 2021, 10:48am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/18 "2021-11-04T10:48:58Z")

</div>

List.GroupByFunction or List.GroupByKey?

---

<div class="post-metadata">

**Author:** ![Marcel\_Rijsmus](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/marcel_rijsmus/32/8539_2.png) [@Marcel\_Rijsmus](https://forum.dynamobim.com/u/Marcel_Rijsmus)\
**Post date:** [November 4, 2021, 10:55am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/19 "2021-11-04T10:55:06Z")

</div>

In this case the number of bike parking spaces is calculated per unit, not per Area.

> **[STEDENBOUWKUNDIGE VERORDENING INZAKE PARKEERPLAATSEN EN FIETSSTALPLAATSEN BIJ...](https://docplayer.nl/9637677-Stedenbouwkundige-verordening-inzake-parkeerplaatsen-en-fietsstalplaatsen-bij-het-creeren-van-meerdere-woongelegenheden.html)**
>
> STEDENBOUWKUNDIGE VERORDENING INZAKE PARKEERPLAATSEN EN FIETSSTALPLAATSEN BIJ HET CREËREN VAN MEERDERE WOONGELEGENHEDEN Art. 1 - Toelichting Sedert de afschaffing van de omzendbrief van 17 juni 1970 betreffende

Am i up to date?

---

<div class="post-metadata">

**Author:** ![Antonio\_onelab.nl](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Antonio\_onelab.nl](https://forum.dynamobim.com/u/Antonio_onelab.nl)\
**Post date:** [November 4, 2021, 11:07am UTC](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941/20 "2021-11-04T11:07:13Z")

</div>

The municipalities determine the amount off bike parking spaces ( and also offcourse car parking spaces) based on the total area per unit. Every range off unit area’s has a minimum amount of bikes needed.  
E.g. \< 50m2, 3 bikes, 50m2\< 65m2, 3 bikes. Etc. I have made a calculated value of this in a schedule. It works perfectly with areaplans. But if you use rooms, it looks at every room individualy, instead of the total area per unit. You can display it as a total when you uncheck “Itemize every instance”, but the schedule still looks at every instance!  
So you get the wrong numbers  
That’s why I was looking at Dynamo. It is also a good way to start determening the GBO via Rooms instead of Area’s.

But mayby I’m missing something in Schedules.

[Next page](https://forum.dynamobim.com/t/collect-room-area-by-parameter-name/69941.md?page=2)