Compare Characteristic Values
I have run into a situation where I need to compare 2 characteristic values in a query. I have one characteristic named "Sales PNL" and one characteristic named "Financial PNL". The values for these characteristics are text like "BREAD" or "CEREAL". I need to create a query that returns all the rows where "Sales PNL" does not equal "Financial PNL". So, a row where both characteristics equal each other should not be returned from the query, but a row where one characteristic equals "CEREAL" and one equals "BREAD" should be returned from the query. Any ideas on how to accomplish this?