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?