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

    Excluding NULL & -ve Values

    Dipesh Vadgama



      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.