2 Replies Latest reply: Sep 17, 2016 8:07 AM by Vineeth Pujari RSS

    YTD calculation: shows total not YTD?

    josh flory

      I am trying to get a YTD calculation to work.

       

      I used examples here:

      YTQ, QTD, MTD and WTD

       

      However, it always returns the TOTAL SUM so if I just do SUM(MySalesField) it gets the same result as:

      Sum({$<Date = {'>$(=Max(([Fiscal Year](Date)))) <=$(=Max(Today()))'}>} [MySalesField])

       

      or

      SUM({$<[Calendar Date] = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'}>}[MySalesField])

       

       

      I am not really sure how to parse that.

       

      What I would expect is that with no calendar applied to the visualization I would just get YTD for sales for this current year (2016).

       

      That isn't happening though, I am getting total of ALL sales.

       

      Thanks!