IsNull LEN TRIM Function not working

[vinestim]

When I uncheck the Include null values option,  my Null values go away. But this formula in my calculated dimension does not turn those nulls to my default. 60% of the dimension is Null, but my default returns less than 1% as "No App Found". Please let me know if there is something that I am overlooking. I have tried the IsNull and Len separately and neither of them are calculating to "No App Fount":

1. =If(  trim(TestField) = '-' , 'No App Found' ,TestField)
2. =If( IsNull( trim(TestField) ), 'No App Found' ,TestField)
3. =If( LEN( trim(TestField) ) < 1, 'No App Found' ,TestField)
4. =If(IsNull(trim(TestField)),'No App Found' , If(LEN(trim(TestField))<1, 'No App Found' , If(trim(TestField)= '-', 'No App Found' , TestField)))

[Stoyan_Terziev]

Hi Vinestim,

Your Nulls will always disappear if you uncheck 'Include null values'. You can't bypass that by doing something like

If(IsNull([Field]), 'Show it', [Field])

Because it's genuine 'null' value which has already been excluded before the chart even starts calculating.

If you want to add them, you should do that on the back-end when you are loading the data itself.

I hope that helps!

Kind regards,

S.T.