2 Replies Latest reply: Aug 1, 2018 9:45 AM by Sunny Talwar RSS

    Set analysis or IF not equal to any value from dimension

    Jurien Groot

      Hi,

       

      I want to compare a column A with values, say value A to all possible values from column B, eventhough they are not related in the same row.

       

      Column AColumn B
      AX
      BY
      BZ
      CA
      CZ

       

      For this example I want to compare COUNT(IF(Column B <> All possible values of Column A, 1)) This should result in 4.

       

      I cannot find the syntax to compare to unrelated values.