Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have calculated YTD by using below link
Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)
But i need to exclude January 1st and 2nd from the calculation.
Is it possible.
Thank You
May be this:
Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum)) + 2))<=$(=Max(DateNum))"}>} Sales)
May be this:
Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum)) + 2))<=$(=Max(DateNum))"}>} Sales)
Are you need YTD from weekStart ? Update the YTD flag in the script to compensate tthe weekstart instead of Jan 1st.