6 Replies Latest reply: Jul 1, 2018 9:28 PM by ahmad albab RSS

    How can I display result which is greater than 0?

    ahmad albab

      Dear Friend,

       

      My result display value which include 0 & negative. how to modified my formula to exclude it? Thanks.

       

      Have a nice day :-)

       

       

       

       

      =Count({$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

       

      *$<[SR No]-={"''"}>

       

      *$<[Gate]={"Gate C"}>

       

      }

       

      (Gate))-count([SR No])