1 Reply Latest reply: Apr 26, 2010 11:27 AM by carneyfm RSS

    simple if statement question from a beginner

    rappindre69

      I would like to display values in a single column of a straight table in two different colors. The column is "Margin %" and I would like to display it in red if it is under 20% and green if it is over 20%.

      Unfortunately, I can't even get a simple if statement to work. It may be my syntax, as I've never done it before. Under the definition for "Text Color" in my Margin % expression, I have

       

      IF(Sum(Margin) / Sum(Sales) <= 0.2) // that margin / sales is how i calculated the margin percent...

      red();

      ELSE

      green();

      end if



      I can't even get a simple if statement to work. But that's what I need to do.

      Thanks!