## How Indicators works

 Author Message gabi.vasile Forum Newbie Group: General Forum Members Points: 6 Visits: 220 Hello everyone - I was wondering if anyone can provide some insight on how indicators work. I read about the percentage rule but when I do the math it doesn't make any sense. Here is an example using percentage rule, with Auto for Min and Max-- see attachment alsoITEM VALUE STATEItem A 69,622.1990 REDItem B 47,987.9352 YELLOWItem C 11,237.4420 REDItem D 12,063.1895 REDItem E 42,324.9775 YELLOWItem F 24,539.4310 REDCan anyone explain why?Here is the math: PERC OF MAX PERC OF SUM 69,622.1990 100.00% 33.51% 47,987.9352 68.93% 23.10% 42,324.9775 60.79% 20.37% 24,539.4310 35.25% 11.81% 12,063.1895 17.33% 5.81% 11,237.4420 16.14% 5.41% SUM 207,775.17 MAX 69,622.20 Why would 24,539 be on RED?Thank you! Attachments 5-23-2013 9-53-45 AM.bmp (17 views, 249.00 KB) mysorian Valued Member Group: General Forum Members Points: 50 Visits: 101 Indicators are just like conditional formatting. Your text showing the table in this post is all mixed up. Why don't you leave some space to see the separate columns? gabi.vasile Forum Newbie Group: General Forum Members Points: 6 Visits: 220 Thank you for the reply. if the indicators act similar with conditional formating then why the need for percentage values? if we select numeric then indeed it will act as conditional formating based on numeric values; but when percentage is used it should select values based on percentage of that value from the total.It doesn't work that way. mysorian Valued Member Group: General Forum Members Points: 50 Visits: 101 Can you email me the file? I would like to check and will get back to you.mysorian@gmail.com gabi.vasile Forum Newbie Group: General Forum Members Points: 6 Visits: 220 I just sent you an email.Thank you!Adrian gabi.vasile Forum Newbie Group: General Forum Members Points: 6 Visits: 220 OK - after some time we figured it out.Basically Microsoft it will divide the results in the intervals specified in the options ( Red > 60, Yello < 60, etc) and based on the indicators value it will determine the state.It will be easier to see it if you sort the data first - top 30% will be in Green, next top 30% in Yellow and so forth.Kind of like a percentile - based on the max of you series.Thank you!Adrian