1 Reply Latest reply on May 13, 2016 8:47 AM by Shinichiro Murakami

    Calculated field for conditional format. LoD needed?

    Diogo Braga

      I am trying to conditionally format these squares on the left. But when I apply my formula (listed below) I get more fields. The reason is that the data set has schools by grade levels, so noticed that the formula is grouping the grade levels based on if their colors. Schools that have only one color for all grade levels show only once as expected. I am trying to apply the conditional format for the school as a whole, not have grades grouped by similar colors.

       

      How should I change the formula to get the results I need?

       

      IF [Adjusted Available]>[Pipeline] THEN 'Red'

      ELSEIF [Pipeline]>[Adjusted Available]*2 THEN 'Green'

      ELSE 'Yellow' END

       

      2016-05-13_1049.png2016-05-13_1050.png