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

    If condition statement not fetching if any zero values

    Amyl

      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