5 Replies Latest reply on Jun 6, 2018 9:19 AM by Steve Martin

    COUNTD of IDs based upon values in one column but NULL in other columns

    Ian Yee

      I'm trying to get a distinct count of IDs where one column has values while specific columns are null or blank.

       

      So, in the screenshot below, I want a COUNTD of IDs where the "Primary Office" column has values but the "Supporting Office" and "Administrating Office" cells are null or blank. Basically, the result I should get from the screenshot is a count of 2 IDs since the rows with a value only in the "Primary Office" have values (IDs 1 & 5).

      Capture.JPG

       

      TIA!