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


      then COUNTD([ts_task number])

      ELSE Null