Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I made an expression to compare the sales of last day with the same week correspondent of day of the last year, and it worked fine.
=Sum(
If(
(Num(YearName(DATA_VENDA),'YYYY'))=(num(YearName(today(),-1),'YYYY')) and
(Date(Month(DATA_VENDA),'MMMM'))=Date((Month(today())),'MMMM') and
(Date(Week(DATA_VENDA),'WWWW'))=Date((Week(today())),'WWWW') and
(WeekDay(DATA_VENDA)=WeekDay(today()-1))
,VALOR_VENDA
)
)
Now I´m trying to set an expression to the label of this expression, to show the date used in the result of the expression above, that is the same day week of yesterday, one year ago (i.e. 06/19/2008) - it was thursday, like yesterday.
Use makeweekdate function