How exclude null

[pgalvezt]

Hello,

How can exclude null values from calculated field?

Right(If( Left(Field,1) = 'M', Field),1) as Result

This Form Has null Values and I want to remove them.

Thanks!!

[trdandamudi]

check "Suppress when Value is null" under the dimension tab..

[sunny_talwar]

So you want to remove Null from your new Column Result? Or are you looking to assign another value to Field when it is Null?

[swuehl]

Maybe something like

LOAD *

WHERE LEN(TRIM(Result));

LOAD

     Right(If( Left(Field,1) = 'M', Field),1) as Result

FROM YourTableSource;

or

LOAD *

WHERE NOT ISNULL(Result);

LOAD

     Right(If( Left(Field,1) = 'M', Field),1) as Result

FROM YourTableSource;

[maxgro · Accepted solution]

load

     .....,

     Right(If( Left(Field,1) = 'M', Field),1) as Result,

     .....

from

     .....

Where Left(Field,1) = 'M';

[MarcoWedel]

Hi,

just one remark:

some other way to test the initial letter being 'M' besides

Left(Field,1) = 'M'

could be:

Field like 'M*'

hope this helps

regards

Marco