5 Replies Latest reply: Apr 20, 2015 11:06 AM by Sunny Talwar RSS

    Sum and Filtering using dates

      I am attempting to create an expression that allows me to sum a value based on the max date. I am able to successfully get this to work with the following:

       

      BS Fiscal Year Column = 2014

       

      Sum({$<"BS Fiscal Year"=

      {$(=max("BS Fiscal Year"))}>}

      [Total Adjusted Fair Value])

       

      Balance Sheet.png

       

      When attempting to do the same, but using a date formatted MM/DD/YYYY

       

      BS Date Column = 12/31/14

       

      Sum({$<"BS Date"=

      {$(=max("BS Date"))}>}

      [Total Adjusted Fair Value])

       

      I am not getting any results.  Any idea why?