6 Replies Latest reply: Apr 14, 2015 5:41 AM by Manuel Carmona RSS

    Set analysis. Count empty cells

    Manuel Carmona

      Hi there.

       

      My problem has to do with empty cells and how to consider them in set analysis expressions.

       

      I've got the following data:

      image_1.bmp

      And I want a measure to count those queries not yet replied. I.e, something like:

       

      Count({$<Query_date={"*"},Response_date={''}>}Id)

       

      But I can't figure out what to put instead of the red bit {''} to make it work.

       

      The cells in the Excel file have no content.

       

      I've been reading about null() and unsuccessfully tried different alternatives, like:

       

      Count({$<Query_date={"*"},Response_date={""}>}Id)

      Count({$<Query_date={"*"},Response_date={"null"}>}Id)

      Count({$<Query_date={"*"},Response_date={'null}>}Id)

      Count({$<Query_date={"*"},Response_date=isnull()>}Id)


      Nothing works.


      I'd appreciate it very much any guidance on the subject.


      Thanks in advance.

      M.