Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi All:
The existing questions in the forum got me this far (thanks to all previous posts), however I am stuck.
I have an existing calculating that gives me YTD Sales thru Current Week, I am trying to do same thing but for last year and I am striking out. See below.
Ray
// Trying to get sales thru current week for last year. I got it to work for current, but having issues for last
// These are my revised date statements and yield the dates I want
//addmonths(YearStart(Today()),-12)
//AddMonths(WeekEnd(Today()),-12)
//New Code for LAST YEAR
SUM({$<KEY_DATE = {'>=$(=addmonths(=YearStart(Today()),-12))<=$(=AddMonths(=WeekEnd(Today()),-12)}>}[Invoice Subtotal])
//ORIGINAL CODE FOR CURRENT YEAR
// SUM({$<KEY_DATE = {'>=$(=YearStart(Today()))<=$(=WeekEnd(Today()))'}>}[Invoice Subtotal])
May be this:
Sum({$<KEY_DATE = {'>=$(=YearStart(Today(), -1))<=$(=WeekEnd(AddYears(Today(), -1)))'}>}[Invoice Subtotal])
or
Sum({$<KEY_DATE = {'>=$(=YearStart(Today(), -1))<=$(=AddYears(WeekEnd(Today()), -1))'}>}[Invoice Subtotal])