Hi
I'm trying to write a IF statement to state
IF SALES_ORDER.NOTES_1 , SALES_ORDER.NOTES_2 or SALES_ORDER.NOTES_3 is populated show 'SERIAL NUMBERS' but if not populated leave blank.
I have tried the one below but serial numbers is showing when it is and is not populated.
SALES_ORDER.NOTES_1 LIKE "" ? " Serial Numbers" : SALES_ORDER.NOTES_2 LIKE "" ? " Serial Numbers " : SALES_ORDER.NOTES_3 LIKE "" ? " Serial Numbers " : SALES_ORDER.NOTES_1
any help would be grateful :)