Report Builder - Weird Error does not detect % values > 0

[mpuricelli]

Hi all,

I've encountered a weird quirk in Report Builder driving me crazy.

I use an expression in my chart below to change the series fill color based on the value. Positive values should be shown in blue and negative values in red.

The formula being used is: 

=IIF(Fields!ID__Difference_with_Market_25th.Value > 0, "#1a88ff", "#ff8811")

These values in the dataset are percentages, for example, 0.026 or 0.13, and shown as % in the chart.

The expression works fine for all bars except 2 values: 0.026 (3% in orange, which should be blue as it's above 0) and -3% showing in blue despite being a negative value.

I've tried adding decimals (> 0.0000) but this does not fix the problem.

Does anyone have any advice?

Thanks!

[Anonymous]

Hi @mpuricelli 

You may try multiplying 100 to the field value then comparing it with 0. 

=IIF(Fields!ID__Difference_with_Market_25th.Value*100 > 0, "#1a88ff", "#ff8811")

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[mpuricelli]

Hi Jing,

Thanks for your reply.

I thought of that and tried it before, but it did not work, unfortunately.