4 Replies Latest reply: Mar 3, 2016 10:47 AM by Tony C RSS

    Question on Count - COUNT(DISTINCT  (IF (SALES - PLAN) < 500) PRODUCT)

    Tony C

      I want to do a distinct count if the Sales - Plan < 500 as I have duplicate records in the data

      COUNT(DISTINCT  (IF (SALES - PLAN) < 500) PRODUCT) ?