Sage 100

Picking Sheet v4.5. I am trying to suppress the Ship to Address formula data when there is data populated in a UDF (it happens to hold an ""alternate"" ship to address), but I can't get the formula field data to suppress. I placed the UDF on top of the Ship-to address formula and the goal is to display the Alternate ST data when it is present; otherwise print the formula data. I've tried 2 suppression formulas on the ST formula field that aren't working for me: 1. UDF_field <> """" 2. isnull ({UDF_field}) Attached Report Options settings What am I doing wrong?

both formulas look ok to me, I always check the box for ""convert other NULL values to default. have you tried that already? or do you have it off for a specific reason?

What @DavidOverholt said or you could just use a formula for the ship-to address - if UDF_field <>"""" then UDF_Field else (whatever the regular ship to formula is).

@DavidOverholt I did have it checked at one point. I've been checking boxes on and off trying to get this to work.

try turning that checkbox back on then: try using trim(UDF_field )<> """" that would eliminate the possibility that you have spaces in the UDF (spaces are not NULL) Theresa's idea is good too, if nothing is working I always put the UDF that I'm checking against on the form so I can see it in the same section where I'm trying to suppress sometimes I see a value in there that I did not expect.

Fixed! @DavidOverholt I turned on the checkbox & added ""trim"". Thanks!