0 Replies Latest reply: Jul 3, 2014 6:54 AM by Ravi Kiran RSS

    Compare Values in same column and return traffic lights

      Hello Team,

       

      I have a column which shows YoY % for different types of membership , however , i need to compare the YoY % for diff countries and return traffic lights based on that. Below is the snapshot to get better understanding

       

      Capture.PNG.png

       

      so when you look at the Q1'13YoY % , there are values across 5 types of membership, the desired outcome is

                     The maximum value out of this list should be identified

                     The 25% (1.25 out of 5 -rounded off to 2)of the highest values should be green

                     The next 50% (2.5 out of 5 rounded off to 2)of the values should be orange

                     The 25% (1.25 out of 5 rounded off to 1) of the highest values should be green

       

      PS**The logic behind rounding off is just due to make the green one's more presentable

       

      Can you please help me achieve this ???

                    

      Kind Regards,

      Ravi