17 Replies Latest reply: Apr 22, 2015 12:43 PM by Sunny Talwar RSS

    Sum Values using the addyears function with date format MM/DD/YYYY

      I am attempting to sum a value of a column of data using the date with a format of MM/DD/YYYY.  I am using the following expression and having no luck.

       

      =Sum({$<[POS Date]={"$(=addyears(Date(Max([POS Date]),'MM/DD/YYYY'),-1))"}>}[POS Adjusted Fair Value])

       

      Any help would be appreciated.