5 Replies Latest reply: May 22, 2013 5:45 AM by Mark Sheraton RSS

    Display a certain formula (traffic-light-gauge) in one line only?

    Friedrich Hofmann



      I have a table diagram with two lines - in one line, there are budgeted figures, in the other there are the actual figures.

      I have added a traffic-light-gauge that should turn green when a specific cell in the 2nd line is greater than the same cell in the 1st line, otherwise it should turn red.

      The trick is, this traffic-light-gauge should only be displayed in the 2nd line (actual figures).

      Sorry, this sounds terribly easy and basic, but it seemingly isn't - I can use set_analysis to compare the same column in two different lines, but whenever I try to include an IF clause to display the traffic_light only in the 2nd line, it disappears altogether...

      Thanks a lot!

      Best regards,