The value "N" is not accepted as initial value or in a list

[robbertzalm]

Hey there,

I am trying to create a column 'winddirection' in which I use a list of possible options.

In the 'suggested values' option for the column I use:

LIST(ZW, W, NW, N, NO, O, ZO, Z)

This is giving me an error because the value "N" is not accepted.

Expression '=LIST(ZW, W, NW, N, NO, O, ZO, Z)' was unable to be parsed: Unrecognized token: N.

Also not as initial value.

Why can't "N" not be used as a value.

[Suvrutt_Gurjar · Accepted solution]

Please try 

LIST("ZW", "W", "NW", "N", "NO", "O", "ZO", "Z")

[Suvrutt_Gurjar · Accepted solution]

Please try 

LIST("ZW", "W", "NW", "N", "NO", "O", "ZO", "Z")

[robbertzalm]

Works like a charm.

Thank you very much

[Landan_QREW · Accepted solution]

Make sure each element matches the column base type. (check the base type attribute if an enum or enum list column).

If TEXT, then you will need quotes around each element in the list: 
LIST('ZW', 'W', 'NW', 'N', 'NO', 'O', 'ZO', 'Z')

[robbertzalm]

Also this works like a charm.

Thank you very much