question

tiwaryrohit143 avatar image
tiwaryrohit143 asked

I have 8 columns in ssrs report and their values are in decimal and its percentage like 15.23% . i want to fill background color to red if vales of these columns are greater than 15.00% or less than -15.00%

I have 8 columns in ssrs report and their values are in decimal and its percentage like 15.23% . i want to fill background color to red if vales of these columns are greater than 15.00% or less than -15.00%

=IIF(ABS(Fields!ID__Change_from_Prior_cycle.Value) > 15.00 ,"Red", "No Color")

This command is not working.

sql-server-2008ssrsdecimal
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
wisey avatar image
wisey answered

I think it would need to be

=IIF(ABS(Fields!ID__Change_from_Prior_cycle.Value) > 0.15 ,"Red", "No Color")

as 15% is stored as a decimal which is equal to 0.15 with 1 being 100%

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.