SSRS Indicator control and negative percentage

11 May


It seems the SSRS Indicator does not like negative percentages. I have a client who is trying to get the variance to goals calculations. The calculations are (Actual Sales – Sales Goals) / Sales Goals. Guess what sometimes the Actual Sales are lower than the Sales Goals. So, they do get negative numbers. They wanted to display red when the values are between -90% to -10%. Yellow when the values are -10% to 0%. And anything above 0 should be green. When I used percentage on the indicator I was getting green all the time because it seems SSRS ignores the negative numbers.


Just don’t convert it to percentage. Just get the calculation value as it is and make the indicator go against the numbers. For the range values you enter -0.90 to -0.10 for red, -0.10 to -0 is yellow and 0 to 100 is green.

Problem solved! Customer is happy! Me happy!

1 Comment

Posted by on May 11, 2011 in SQL Reporting Services


One response to “SSRS Indicator control and negative percentage

  1. Chad Baldwin

    May 9, 2017 at 8:31 pm

    I know this was posted 5 years ago…but I just found it after searching how to use the indicator on a percentage.

    Why wouldn’t you just write your formula to output positive numbers? Such as Actual Sales / Sales Goals? If sales goal is 100 and you sell 10…then you sold 10% of your goal….if you sell 110, then you sold 110% of your goal…


Leave a Reply to Chad Baldwin Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: