Avatar of srodgers45

asked on 

SSRS Expression

I need to show text after a field in SSRS. I am able to do an "If, Then" to replace a value, but would like to show text after the standard value. This is the expression I currently have:

=IIF(Fields!ACFD_Arrival_Min.Value = 0, "First", Fields!ACFD_Arrival_Min.Value)

in addition to that I would like to add text after the "Fields!ACFD_Arrival_Min.Value" at the end of the expression that would display "After ACFD Unit" for any value greater than the "0" which will display as first.

Example below: I would like to add "After First Unit" to the numeric values in the 'ACFD Arrival Min' Column, but not after "First" value in the expression, that will just remain "First".

Sample Data

Avatar of undefined
Last Comment

8/22/2022 - Mon