Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 How Indicators works Rate Topic Display Mode Topic Options
Author
 Message
 Posted Thursday, May 23, 2013 8:05 AM
 Forum Newbie Group: General Forum Members Last Login: Monday, December 09, 2013 10:34 AM Points: 4, Visits: 134
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 also

ITEM VALUE STATE
Item A 69,622.1990 RED
Item B 47,987.9352 YELLOW
Item C 11,237.4420 RED
Item D 12,063.1895 RED
Item E 42,324.9775 YELLOW
Item F 24,539.4310 RED

Can 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!

Post Attachments
 5-23-2013 9-53-45 AM.bmp (17 views, 249.87 KB)
Post #1456026
 Posted Monday, June 10, 2013 5:45 PM
 SSC Rookie Group: General Forum Members Last Login: Monday, November 25, 2013 7:25 PM Points: 39, Visits: 73
 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?
Post #1461820
 Posted Tuesday, June 18, 2013 7:42 AM
 Forum Newbie Group: General Forum Members Last Login: Monday, December 09, 2013 10:34 AM Points: 4, Visits: 134
 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.
Post #1464657
 Posted Tuesday, June 18, 2013 12:43 PM
 SSC Rookie Group: General Forum Members Last Login: Monday, November 25, 2013 7:25 PM Points: 39, Visits: 73
 Can you email me the file? I would like to check and will get back to you.mysorian@gmail.com
Post #1464835
 Posted Tuesday, June 18, 2013 12:59 PM
 Forum Newbie Group: General Forum Members Last Login: Monday, December 09, 2013 10:34 AM Points: 4, Visits: 134
 I just sent you an email.Thank you!Adrian
Post #1464842
 Posted Thursday, June 20, 2013 7:51 AM
 Forum Newbie Group: General Forum Members Last Login: Monday, December 09, 2013 10:34 AM Points: 4, Visits: 134
 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
Post #1465709

 Permissions