Filter wall functions and area to Excel

Hej Dynamo experts :slight_smile:

I’m new to dynamo.

What I’m trying to do, is to export all exterior wall types and their areas to an excel document.
I have filtered the exterior walls and linked them to my excel (and it works), The problem is, that I also want the total area of each wall type.

I have tried everything, but can’t figure out how to do this :frowning:

Hope you guys can help me!

Get exterior wall and their areas

Walls have a parameter called Area, you can get those values and use a Math.Sum node

Yeah I have tried that, but it give me the total area of all the wall.

As you can see on the picture, I have filtered the walls to 3 types of exterior walls: Testvæg, CW 102-85-140p and Exterior - Block.

Now i want the total area for each type of walls.

Thanks for the quick answer :slight_smile:

You can not get an area on a wall type, you need to get your instances first

So what i need to do is to get the area and type instances, then filter exterior/interior walls? :slight_smile:

You should probably sort your selected walls by type just after filtering them by the Function type parameter.
A SortByFunction node could be helpful, please browse the forum to see how it works.
http://dictionary.dynamobim.com/#/BuiltIn/Action/SortByFunction

Thanks I will take a look