How to use iif statement to highlight values only when a decimal value but not .00

Question

Hi - I want to highlight values in a column when they are not 22.00 but 22.95 etc o only when the decimal values are more than 0.

Answer 1

To highlight values in a column only when the decimal values are more than 0, you can use the IIF function in combination with the DecimalPlaces property of the field. Here's an example expression that will highlight values in a column only when the decimal values are more than 0:

=IIF(Fields!MyField.Value - Fix(Fields!MyField.Value) > 0, "Yellow", "No Color")

In this expression, MyField is the name of the field that you want to format. The Fix function is used to return the integer portion of the value, and the IIF function is used to check if the decimal portion is greater than 0. If it is, the expression returns "Yellow" to highlight the value, otherwise it returns "No Color" to leave the value unhighlighted.

---

References:

• Expression examples in paginated reports (Report Builder)
• How to control and understand settings in the Format Cells dialog box in Excel