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(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?

ssrs traffic light indicators

1 Reply

  • 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.