3 Replies Latest reply on Nov 1, 2013 2:38 AM by David Goldstone

    Calculated Field on Colour Shelf

    David Goldstone

      Hi

       

      I have one chart with 2 measures where I would like to format the colour of the bars/circles based on the values. The first calc below is the one that I have used to determine the colour of the first measure, and the second is the calc for the second measure.

      How do I merge these two together so the colour of the bars reflect the right calculation?

       

      IF AVG([Score]) <=96  THEN "Below average"

      ELSEIF AVG([Score]) >96 THEN "Above average"

      END

       

      IF AVG([Rank]) <=9000  THEN "Below"

      ELSEIF AVG([Rcore]) >9000 THEN "Above"

      END

       

      When using this one below it colours all bars/circles on the first part.

       

      IF AVG([Score]) <=96  THEN "Above average"

      ELSEIF AVG([Score]) >96 THEN "Below average"

      ELSEIF AVG([Rank]) <=9000  THEN "Below"

      ELSEIF AVG([Rcore]) >9000 THEN "Above"

      END

       

      Thanks