3 Replies Latest reply: Feb 28, 2017 2:00 AM by Rahul Pawar RSS

    changing values with colours using IF statement error

    Royce Tang

      Dear experts,

       

      I am currently using an IF loop to change a certain value to green/red when a condition is met the expression I am currently using is:

      if($(v%rev), green(), red())

       

      the logic seems correct to me however I am getting weird values in the straight table seen in the attached picture.

      I have also attached a qvw file for your reference.

       

      Kind regards,

      Royce Tang