Forum Discussion
Report Builder - Weird Error does not detect % values > 0
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 s...
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!
Hi Jing,
Thanks for your reply.
I thought of that and tried it before, but it did not work, unfortunately.