orlando Teixeira Posted August 12, 2009 Share Posted August 12, 2009 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 Quote Link to comment
Gerrit Posted August 12, 2009 Share Posted August 12, 2009 Edit the criteria line to read : =DATABASE(((L='PISO 0') & ((R IN ['Space']) & ('Space'.'Name'<>'porch')))) (assuming the unwanted space is named porch) Quote Link to comment
orlando Teixeira Posted August 12, 2009 Author Share Posted August 12, 2009 Thx Gerrit It worked Perfectly, nice tip. Quote Link to comment
Pat Stanford Posted August 12, 2009 Share Posted August 12, 2009 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. Quote Link to comment
Recommended Posts
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.