3 Replies Latest reply on Oct 12, 2016 1:23 PM by Lisa Li

    Count distinct if multiple conditions met

    Nathan Graham

      Hello and thank you,

       

      In the attached workbook I am looking to countD the number of 'ts_task_number'  where the 'Question#' = 1 and the 'sr_answer' = 0,1,2,3

       

      I've tried using this calc field, but keep getting errors.

       

      if([Question#]==1 and

      ([sr_answer]==0,1,2,3))

      then COUNTD([ts_task number])

      ELSE Null

      END