Jump to content

Recommended Posts

Hi,

 

Establishing criteria for databases is easy: 

 

Database header cell: =CompAreaByClass('Class-1') using the previous function and establishing criteria I manage to show results only form a particular layer.

 

What I can't do is the following, I want in a normal worksheet cell to get the area of my components but specify from which layer.

I know I have to use this function:

 

 Spreadsheet cell: =CompAreaByClass(t=wall,'Class-1')

 

What do I need to add to the function above to specify the search in a particular layer?

 

Thanks in advance,

 

Martín

 

Share this post


Link to post

=CompAreaByClass(((L='Design Layer-1') & (T=WALL)), 'Class-1')

 

You can use the Insert Criteria function in the Insert menu of the worksheet to create just about any criteria combination that you need.

  • Like 1

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×