2 Replies Latest reply: Mar 13, 2018 11:44 AM by Wanyun Yang RSS

    Please help with my function!

    Wanyun Yang

      Hi guys,

       

      I have a table as shown, each row is a visit record:

      Date  Customer  Item  Checked

      1-1          001          A          1

      1-1          001          B          0

      1-2          001          A          0

      1-2          002          A          0

      1-3          002          B          1


      I want to count the number of visit records with nothing checked each day with each customer. The result should be like:

      Date  Customer  Count

      1-1          001          0

      1-2          001          1

      1-2          002          1

      1-3          002          0



      My function is like:

      SUM(IF(Aggr(SUM(Checked), Date&Customer)=0,1,0))


      But it shows nothing at all. Please help! Thanks in advance!