SSRS Formatting for negative numbers

Question

Ok, so I am familiar with formatting the colors of a cell like this

=IIF(SUM(Fields!Dollars.Value) < 0, "Red", "Black")

but, I have inherited a report that has 80 columns and 4 rows of calculated fields which all print out black. I have been tasked with changing the format to represent negative numbers as red.

Does anyone know of an easy was to represent "CurrentValue" in a formula instead of referencing the textbox or report field?

Something along the lines of

=IIF(SUM(CurrentCellValue) < 0, "Red", "Black")

This way I can select the whole table and add this formula to the font color. Otherwise I will have to change the formula on 80*4 fields. I really don't want to do that

niktrs · Accepted Answer · 2017-01-25T07:01:22.170

20

In the Color expression of the fields use the code below

= Iif (Me.Value <0, "Red", "Black")

edited Jan 25 '17 at 07:01

answered Jan 25 '17 at 06:55

niktrs

9,858
1
30
30

8

It might be worth mentioning that this can be set for multiple cells at once. Open the Properties window (F4), select all the cells that need the format, and put the expression into the `Color` property. – Pete Rennard-Cumming Jan 25 '17 at 09:36
YES! That's it. Amazing. Took me 2 minutes to implement vs. hours and possible mistakes. Thank you. – Jmyster Jan 25 '17 at 19:27
About Niktrs solution it should be me.value instead of Me.Value – Mohsen Ismail Nov 27 '18 at 14:15
2

Nice but only worked for me when I removed the spaces before and after the Iif – Standage Dec 19 '19 at 17:01

SSRS Formatting for negative numbers

1 Answers1