Jump to content
Sign in to follow this  
orlando Teixeira

spreadsheet mind blooing morning :( newbiew question

Recommended Posts

Hello PPL,

i am trying to limit the criteria of an spredsheet.

This is what i got:

"=DATABASE(((L='PISO 0') & (R IN ['Space'])))"

It gives me the Spaces inside my Building , level 0 (PISO 0 - Portuguese)

Now my problem is that i want to remove from that list for example the porch that also as an space area.

Is it possible to remove from the list some or several spaces using the criteria ? i am not achieving it ....

Thx in advanced

Share this post

Link to post

Edit the criteria line to read :

=DATABASE(((L='PISO 0') & ((R IN ['Space']) & ('Space'.'Name'<>'porch'))))

(assuming the unwanted space is named porch)

Share this post

Link to post

If you have multiple areas you want to exclude you could put them in a class and exclude the class something like:

=DATABASE(((L='PISO 0') & ((R IN ['Space']) NOT (C='porch_class'))))

I think both Geritt's and my solutions can be entered through the criteria builder and not have to be done by hand.

Share this post

Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  


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.

  • Create New...