1 2 Previous Next 20 Replies Latest reply on Feb 2, 2016 12:42 PM by ChandraSheker A

    Counting

    ChandraSheker A

      Hi everyone,

      I have attached a Sample excel file please see that. it has columns   Received Date, Q Date, Customer ID.

       

      I have a requirement which is

      If Q date is not null then it should be counted or displayed as 1, So that i get to know number of customer with Q dates. Respective to Received Date.

      i tried to use  COUNTD(Qdate) which i believe counts all non Null values. But the numbers are not matching, May be few Customers ID's share same Q date.

       

      Please let me know if i am missing anything to get what i am thinking.

        1 2 Previous Next