Reporting service indicator shows wrong color

Question

I will start with a picture (I know it's a bit difficult to see):

As you can see in the report I have three groups:

Organization level 1 - with some grade and indicator
Second group grouped by the entity type (person of organization) and each one has an average grade with indicator
The third section is a list of persons of organization with their grades and indicators

The indicators are set follows: Indicator Set

The problem is that sometimes the indicator shows the color yellow when the grade is 100 (the indicator should show the color green).

I have checked the following:

I have started to think that this is a bug of Report builder 3 / Reporting services

You do Avg(Grade) have you checked your Grade values? Do they match? — eestein
Its working for me. only thing i have done diffrent is RED 0 - 60 Yello 60.01 - 85 Green 85.01-100 — Hiten004

glh glh · Accepted Answer · 2013-01-15T09:35:22

I have a few suggestions.

Can you add decimals to the output to see if the yellow 100 is over 100? As these are averages this may effect the upper limit.
Also try putting the colours in order of green to red.

Edit:

Something doesn't match up in your report and / or data as the green "56" acording to tat value should be red, and some of the yellows are to be red.

You need to check the value you print next to the traffic light as these values are not in any way reflective of the vaues you are getting out for the indicators.
Also check the data type on the grade field or may be add a convert funcrtion, say cint() to your expression.