RSS

SSRS Indicator control and negative percentage

11 May

Problem:

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.

Solution:

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!

Advertisements
 
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

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

WordPress.com Logo

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

Google+ photo

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

Twitter picture

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

Facebook photo

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

w

Connecting to %s

 
%d bloggers like this: