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:








      Can anyone help me fix the syntax?