11 Replies Latest reply: Jun 15, 2016 8:14 AM by Sam Maile RSS

    Count Distinct, Multiple Measures (Sum)?


      I have three products which I am trying to sum on a distinct ID number.


      My current set analysis is:

      COUNT ({$< Product_1 = {">0"}>}  DISTINCT ID)


      There are two other products Product_2 & Product_3.



      I have tried adding them together using comma separators, however this prints out the wrong number compared what is printed out trough my SQL code.


      Help would be appreciated.