3 Replies Latest reply: Jan 22, 2013 12:56 PM by Daniel Rozental RSS

    Excluding Nulls from expression

      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