10 Replies Latest reply: Aug 14, 2017 11:45 AM by Dipesh Vadgama RSS

    Excluding NULL & -ve Values

    Dipesh Vadgama

      Hi,

       

      I am trying to do set analysis in Strange table to exclude date which are blank & Day Rem which are in negative.

       

       

      =Count({<[User ID]={'=Len(Trim([Complete Date]))=0'},[Days Rem]={"<=0"}>}[User ID])

       

      But in not get required result.