Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear aLL
i Have to variable
vYearstart=num(Daystart(YearStart(Date(max(PeriodDate)))))
vMaxDate=Max({1<Year=$::Year,Month=$::Month,Quarter=$::Quarter,MonthName=$::MonthName,Day=$::Day>} PeriodDate)
i am Seeing the YTD profit using
PeriodDate={">=$(vYearStart) <=$(vMaxDate)"}
I need to Seen the same Period of Time as per last year
help please,
Maybe like this: PeriodDate={">=$(=addyears($(vYearStart),-1))<=$(=addyears($(vMaxDate),-1))"}
If not, please post a qvw document that demonstrates the problem.
You can try with Addmonths() also
PeriodDate={">=$(=Addmonths($(vYearStart),-12)) <=$(=Addmonths($(vMaxDate),-12))"}