Excluding Nulls from expression

[#1]

Hi all,

I am looking to create a table which contains only the tuples that meet a simple if condition:

     if(Date=LatestUpdate, 'Yes',NULL)

As a calculated dimension I could select the 'Surpress When Value Is Null' checkbox. How do I achieve the same result when using an expression?

The reason that I did not use a calculated dimension is that it resulted in a memory error.

Thanks,

Alan

[danielrozental]

Sorry, I don't get it, null values in expressions are filtered by default.

The correct way to reference a null value is through the null function null().

     if(Date=LatestUpdate, 'Yes',NULL()) or

     if(Date=LatestUpdate, 'Yes')

[#3]

Hi Daniel,

Thanks for your reply.

I would like to suppress the rows that do not return a 'Yes' as per the above IF condition.

Thanks

Alan

[danielrozental]

Alan, a row in a table all graph tha has nulls on every expression will be filtered by default, make sure you have the following optin selected.