Forum Discussion

Karolina411's avatar
Karolina411
Icon for Helper V rankHelper V
2 years ago

Indicator Properties in SSRS- report properties

hello--my calcuations do not seem to be working--I am simply adding indiction for % ranges--look below then look at the report when I do paginated reports - the expression is : =IIF(IsNothing(Sum(Fie...
ssrs traffic light indicators
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Karolina411 

Based on the expressions and screenshots you provided, I've created an indicator using the report for this example below:

I created an indicator using the expression you provided:

When I try to set the same indicator as you, I get the wrong indicator

Setting the maximum and minimum values to 0 and 1 works fine:

 

 

 

In addition, you can get the correct indicator by doing the following:

Set the unit to Numeric and modify your indicator to make it work:

 

 

 

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.