I am trying to do some conditional formatting in SSRS to set the cell to red if the sum is greater than 0, this is based off another sum which is already happening in the report.

This is what I have so far but it errors.

=IFF(SUM(IIF(LEN(TRIM(Fields!TransferStock.Value))=0, 1, 0),"RED","White"))

Thanks

CodePudding user response：

This code will work for the result of whatever is in the textbox.

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

It's referenced in the following Microsoft article.