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_M
in.Value = 0, "First", Fields!ACFD_Arrival_Min.Va
lue)
in addition to that I would like to add text after the "Fields!ACFD_Arrival_Min.V
alue" 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".