orlando Teixeira 0 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 Share this post Link to post
Gerrit 4 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 Share this post Link to post
orlando Teixeira 0 Posted August 12, 2009 Thx Gerrit It worked Perfectly, nice tip. Quote Share this post Link to post
Pat Stanford 647 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 Share this post Link to post