'SSRS conditional formatting based off a sum

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

sqlreporting-services


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions