6 Replies Latest reply on Dec 13, 2013 9:33 AM by Juracy Americo

    Table calculation and color isn't working as expected

    Juracy Americo

      Hi everyone,

       

      First, thank you to Rob Strong and Jim Wahl for the post Getting a count of Above and Below Averages

      From that post I was able to come out with the workbook below.

       

      I did't a calculation field "AboveOrBelowAverage" it is working fine, but for the first sales rep isn't .For the second sales rep to the end it is working fine.

      I 'm missing something here , but I don't know what.

      The desire is to color each period bar by blue when is Above or equal average and red when is Below average .

       

      Any help would be much appreciated.

       

      Sales rep.JPG.jpg