If my year starts from april 15th

[nag78936]

How to write ytd expression if my company starts from april 15th

[vinieme12]

As below

,InYearToDate(Date-if(month(Date)=4,14,0), today(), 0, 4) as YTD_flag
,InYearToDate(Date-if(month(Date)=4,14,0), today(), -1, 4) as Prior_YTD_flag

[nag78936]

hi vinieme

can you explain briefly as i am unable to understand which you have posted

[vinieme12 · Accepted solution]

Create these flags in your master calendar and use the flags in set analysis- for calculations

,InYearToDate(Date-if(month(Date)=4,14,0), today(), 0, 4)*-1  as YTD_flag
,InYearToDate(Date-if(month(Date)=4,14,0), today(), -1, 4)*-1 as Prior_YTD_flag

sum({<YTD_flag={'1'}>}Amount)

sum({<YTDPrior_YTD_flag_flag={'1'}>}Amount)

OR Without flags

sum({<Date={">=$(=Date(YearStart(Max(Date),0,4)+14),'YYYY-MM-DD')<=$(=Date(Max(Date),'YYYY-MM-DD'))"}>}Amount)