Hide zero values in two expressions in one ceil with chr(10)

[Sergio3]

Hi mates!

I need your genius advice.

I have who expressions in one ceil using 'chr(10)', in attach.

Problem is - zero values are showed (because 'chr(10)' is a symbol)!

How to achieve the goal ???

[marcus_sommer]

Maybe with a check like this one:

if(exp1, exp1 & chr(10) & expr2, null())

- Marcus

[Brett_Bleess · Accepted solution]

Sergio, if Marcus' post got you what you needed, please be sure to return to your thread and close things out by using the Accept as Solution button on Marcus' post to mark it.  This gives him credit for the help and lets other Members know his suggestion worked.  We appreciate our Members closing their threads whenever possible.  If you did something different, you can post that and then use the button to mark that post...

Regards,
Brett