How can I summary expressions in a listbox

[#1]

hello together,

i have a table with a lot of companies:

Companies
Company A
Company B
Company C
Company D
Company E

I would like to have a Listbox with two expressions :

Listbox
Company A
Non Company A

Do you know, how can I implementate this logic?

Thank you.

Greetings

Jörn

[kouroshkarimi · Accepted solution]

In your script you could add a simple column to the table along the lines of:

if(Companies='Company A', 'Company A', 'Non Company A') as Filter

And then create a Listbox based on this new Filter field.

[#3]

Make an variable of companies, otherwise you need to hardcode every company.

So vCompanies = Companies

=if(Companies=vCompanies,vCompanies,'NON '&vCompanies)

Is that how you want it?