3 Replies Latest reply on May 25, 2016 6:23 AM by Diogo Braga

    IF THEN statement inside an IF THEN statement

    Diogo Braga

      I need an IF THEN statement inside an IF THEN statement. This is for survey results, if the participation rate is greater than 20% then color code (red, yellow, green, blue) the result, if not then show the result in grey.

       

      Something like this...

       

      IF [Participation Rate]>x% THEN...(apply the calculated field below), IF NOT THEN 'Grey'

       

      IF [%FIELD] < 0.2 THEN 'Red'

      ELSEIF [%FIELD] < 0.4 THEN 'Yellow'

      ELSEIF [%FIELD] < 0.6 THEN 'Green'

      ELSE 'Blue'

      END