8 Replies Latest reply on Oct 4, 2013 6:42 AM by Natalie Woo

    IF ELSE question

    Natalie Woo

      I am trying to fix this :

      IF [@PY Rate] = "NA" THEN "NA"


      STR(({@CY Rate} - INT({@PY DART Rate})) / INT({@PY Rate})*100)


      but an error display and i cannot fix this.

      The error said on this statement    IF [@PY Rate] = "NA" THEN "NA"'


      "cannot compare string and float values"


      please help~