3 Replies Latest reply: Jan 8, 2017 5:48 AM by Yeo Poh sai RSS

    How to filter when my field sEG have missing value ?

    Yeo Poh sai

      HI All

       

      i have try

       

      =if(sEG='A11',sEG)

       

      it can display those A11 company.

       

      may i know how to change the above expression to list missing value ?

       

      i Try :-

       

      =if(sEG=' ',sEG)

       

      it does not work

       

      paul