YTD with excluding specific days

[anuradhaa]

Hi,

I have calculated YTD by using below link

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)

YTQ, QTD, MTD and WTD

But i need to exclude January 1st and 2nd from the calculation.

Is it possible.

Thank You

[sunny_talwar · Accepted solution]

May be this:

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum)) + 2))<=$(=Max(DateNum))"}>} Sales)

[#3]

Are you need YTD from weekStart ? Update the YTD flag in the script to compensate tthe weekstart instead of Jan 1st.