Difference in No.of Weeks?

[devarasu07]

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