Data Modelling, "and" and "or"

[firmographs]

We have a situation where 1 data type (call it a site) has 5 attributes.  

Each attribute is a dimension in the site table.  The possible values for each attribute is yes, no, n/a, unknown, or null.  For example, if the dimension is "near water", those are the 5 possible attributes.  

We are trying to report using some "and" and "or" logic.  For example, which results are "yes" for dimensions 1, 2, 3, and 4, but not 5.  

What is the best way to approach this situation?  

[pradosh_thakur]

I guess you can use the if () and comine the and/or to get the logic as per your requiremnt.

You need to upload some sample data to get a concrete answer on this.

[firmographs]

Sure, I understand.  This is a picture representing our situation.  At least, we'd get a list of results with this logic hard-coded.  Better yet, we could use filters to drive the logic.  

[pradosh_thakur]

=Concat(DISTINCT {<Dim1={'Yes'},Dim2={'Yes'},Dim3={'Yes'},Dim4= {'Yes'},Dim5-= {'Yes'}>}Site)