12 Replies Latest reply: Oct 22, 2013 5:01 AM by Al On RSS

    How do I add a condition to an expression to only include rows where the values of 2 similar fields don't match?

      Hi,

      I have a model where the same information about the population in the model comes from two fields from different sources (tables). To make it easier, let's say I have a list of SKUs for clothing articles, and each can be a S, M, L in size, and that I get the sizes from manufacturing data and from accounting data.

      To validate my data, I want to create a table where only the records where the size values don't match.

      So, I thought I'd try to include in the expression something like:

      [Size from manufacturing]-=[Size from accounting]

       

      But that didn't do the trick......

       

      what should I do?

       

      Thanks!