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])