Expression in Chart depending on columns

[#1]

I have a Chart that has 4 columns with an expression wich gives the result 'X' or ''(space).

A fourth column has to be marked with an 'X' depending on if some of the four previous

columns has an 'X' or not.

I have tried this expression with rreference to columns name.

=if(([OmsG]='X','X','') or ([ROD]='X','X','') or ([roc]='X','X','') or ([POR]='X','X',''))

If I only use the first if it works but not when I add  or

kindly

Håkan

[Anonymous · Accepted solution]

try this Expression (if any of the four columns contain X, Show X, otherwise space

=if(([OmsG]='X' or [ROD]='X' or [roc]='X' or [POR]='X'),'X','')