6 Replies Latest reply: Feb 3, 2016 2:56 PM by Sangram Reddy RSS

    help with prior YTD

    Florence DeBello

      I've been struggling with creating a measure which will sum my sales amount for prior YTD.

      I thought it was the format of the dates in my results, so I went as far as to use TODAY as the both base date and the date to compare and still cannot get a "true" result.

       

      Here is what my measure is set to, TestDate is loaded by the load script from Today(), SalesAmount is the numeric sales value which I want to summarize.

       

      Sum(if(InYearToDate(TestDate, TestDate), 0), SalesAmount))

       

      I would have expected this to simply summarize ALL rows in my table, but instead the result is 0.

       

      What am I misunderstanding?