IF function with an enum

[opdemonchy]

Hi,

I  think I have a relatively simple question. However, I cant find it on the forum. I want normally have an Enum which has the options 0, 1, 2, 3. When I have a 0 I want to show nothing. However if it is higher than 0, I want a column to pop up. 

Above you see the 2 columns

I have this function now

So I put in SHOW IF =  [Enum_name] = 1, [Enum_name] = 2, [Enum_name] = 3, 
However, it does not work.

Can someone help me.

Thanks a lot!

[dbaum]

Here's the necessary syntax for using the OR function:

OR([Foot] = 1, [Foot] = 2, [Foot] = 3)

In case it's helpful, an alternative is the IN function:

IN([Foot], LIST("1", "2", "3"))

Also, consider whether your app design would benefit from using a Number type column instead of an Enum type. That column type accepts only integers, and you can set the minimum and maximum values. That can then facilitate expressions like:

AND([Foot]>=1, [Foot]<=3)

 You could probably even get away with this type of expression without changing the data type since there are ways to convert numeral characters to numeric values.