Forum Discussion
Nurry90
Helper I
Helper ILast YTD calculation non standard date table
Hi All, I am trying to do two things in one; 1 - Create a calculation for last year to date total ( I have used the below calculation, but it is not giving me totals) 2 - Within my calculati...
lbendlin
Super User
Super UserYour filters would only calculate the sales for the same monthweek* of last year, but not the Last Year To Date.
* - that monthweek is a mythical being, you cannot guarantee that the same month last year had the same week numbers
If you want to calculate an actual LastYTD then what you need is to add a calculated column to your dates table that flags all days smaller than "TODAY() minus one year" as valid (true), and then add that filter to the SAMEPERIODLASTYEAR() call.
