How Indicators works

  • 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

    ITEMVALUESTATE

    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!

  • 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?

  • 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.

  • Can you email me the file? I would like to check and will get back to you.

    mysorian@gmail.com

  • I just sent you an email.

    Thank you!

    Adrian

  • 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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply