24 Replies Latest reply: Aug 17, 2017 6:07 AM by Anil Babu Samineni RSS

    Only Null data

    sony sing

      Hi all,

       

      I have an issue with showing the null data .

       

      My Requirment is:  I want to show the data where the completeddate is null/blank.

       

      I have written this expression still its giving the wrong output can anyone suggest the correct expression?

      =aggr(Only({$-<completiondate={"*"}>}numb),numb)

         

       

      I have data like below   :

       

         

      numbtypecompletedatevalues purchase
      1A10-Jan-17100No
      2X11-Jan-17101yes
      3C12-Jan-17102No
      4G13-Jan-17103yes
      5B104yes
      6J105yes
      7ER106no
      8GR17-Jan-17107no
      9HET18-Jan-17108yes