Friday 14 September 2018

SSRS Indicator decimal value and states

We have getting issue sometime with SSRS Indicators, 
while setting numerical logic between below 0 and above 0 some decimal value skipped by the indicators (Showing blank indicator instead of Yellow Circle).

Solution:
below expression will help to make it visible even if the decimal value starts from 0.00001.


Before: 
Red Indicator Start : -1 End : -99999
Yellow Indicator Start: 0 End 0
Green Indicator Start : 1 End : 99999

After: 
Red Indicator Start : -1E-06 End : -99999
Yellow Indicator Start: 0 End 0
Green Indicator Start : 1E-05 End : 99999