3 Replies Latest reply on Oct 30, 2018 9:54 AM by Amyl

    If condition statement not fetching if any zero values


      Hi i would like to get the bar value 0 if there is no records found.


      Here is my calculation.


      IF ROLLNUMBER  < 10 THEN "Access accepted"

      elseif rollnumber <11 and <20 "Access denied"

      elseif rollnumber < 21 and  <30 then "Access Denied"

      else "NA" END


      Thank you