Hi All,
I have used below formula in expression to get the article No.of Weeks difference based on user selected year and week from list box,
=((vCurrYear-(min(TOTAL <ArticleNo> {<Year={'*'},Week= {"*"},Type={'Sales'},StoreName=>} Year(Date)))) *53)+
(vCurrentWeek-min(TOTAL <ArticleNo> {<Year={'*'},Week= {"*"},Type={'Sales'},StoreName=>} Week(AddYears(Date,(year(Date)-vCurrYear)))))
above week difference formula is working fine for current selected year but it's not working for historical year? do you have any suggestion? thanks
Note:
vCurrYear & vCurrentWeek --> created variable for user selected year & Week
Best Regards,
Dev