Expr to show specific values in list box

[surajap123]

Hi All,

I want to show only specific values in my list box. I wrote the below expression but it shows nothing in the list box

=if(Type='Gross' and 'Net',Type)

I infact, want to show only 2 values ie Gross and Net in the Type list box(ie field Type).

[antoniotiman · Accepted solution]

If(Type='Gross' or Type='Net,Type)

[Anonymous]

Try this:

=If(Type='Gross' or Type='Net')

[anbu1984]

=if(Match(Type,'Gross','Net'),Type)