On a saved search, I've got the following formula but end result is trailing commas when the referenced fields are null - is the join function breaking the case statement? This works properly when those fields (all or some) are populated
CASE
WHEN {custentity_alt_email_2} = null
THEN null
ELSE {custentity_alt_email_2}
END
||
CASE
WHEN {custentityalt_email_3} = null
THEN null
ELSE ','||{custentityalt_email_3}
END
||
CASE
WHEN {custentity_alternate_email_4} = null
THEN null
ELSE ','||{custentity_alternate_email_4}
END
||
CASE
WHEN {custentity_alternate_email_5} = null
THEN null
ELSE ','||{custentity_alternate_email_5}
END