List Box Expression Null Value

[#1]

Hi All,

I have two fields in my list box. The first (left side) is the company IDs and the second field (right) is the expression (payment type) I have written in the expression tab of the list box. I need your help in removing the null values from the right side so the company IDs with corresponding payment type is shown.

Can someone guide me towards on how to implement this if it's possible at all?

Thanks in Advance,

[sunny_talwar]

What is your current expression? and are you trying to remove Company IDs where the expression is Null?

[richard_chilvers]

You might want to aim for a Table object. It can list many fields and has the option to Omit rows where a field value is null.

HTH

[#4]

My current expression in the expression tab is POS.paymenttype and the general tab expression is POS.companyids. Yes Sunny I'm trying to remove company IDs where the expression (paymenttype) is NULL.

Thanks,

[sunny_talwar · Accepted solution]

Have you tried this as your list box expression?

If(Len(Trim(POS.paymenttype)) > 0, POS.companyids)

[#6]

Thanks everyone for your kind help.