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"

      ELSE

      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~