Indicator Properties in SSRS- report properties

[Karolina411]

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(Fields!ReadmitsYTDPercent.Value)),0,Sum(Fields!ReadmitsYTDPercent.Value))- look below and the yellow indicator is NOT working

look above and clearly the red is not working--??  Any suggestions?

[v-jianpeng-msft]

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.