7 Replies Latest reply: Aug 2, 2012 9:23 AM by Rebecca Molstad RSS

    Null Values

    Rebecca Molstad

      I want my expression to calculate the sum of 2012 'RevDollars' and include the following conditions:

       

      • StartDate = Prior to 2008 (oldest date in records is 1984)
      • Include Null and Not-Null Values for StartDate (oldest record is 1984, but lots of null values are present in data set)

       

       

      This is what I have so far, but I don't know how to include the null values:

       

       

       

      sum({$<Year={2012},StartDate={'=<2008'}>}RevDollars)

       

       

       

      Can anyone help me fix the syntax?