Expression in Chart depending on columns

Wed, 28 Sep 2016 14:00:08 GMT

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

Re: Expression in Chart depending on columns

Anonymous — Wed, 28 Sep 2016 14:04:47 GMT

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','')