Dimension: not isNull

[TomBond77]

Hi experts

I have a dimension which comes with one value ' ' (null).

I would like to exclude this value by the following formula and surpressing the box "include null values"

=if( isNull(Model), Null() , Model)

This formula is not working as I still see the  Null record.

Any ideas?

Thanks!

[TomBond77 · Accepted solution]

solved it:

=If( Len( [Model] )>1, [Model] )

[RafaelBarrios]

Hi @TomBond77 

I would add trim() just to be sure you clean the null and whitespaces

=If( Len( trim([Model]) )>0, [Model] )

Help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂

[BrunPierre]

Perhaps there could be spaces. This works every time Len(Trim(Field)) = 0

In your case, If(Len(Trim(Model))=0,Null(),Model)