Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a situation where i have to calculate WOW
It is fine if the week falls in the same year but lets say week is 1 and last week will be max of week of last year.
Not getting the solution for the same. Can you please suggest
(Sum({<WEEK = {$(=Max({<Year={$(=MAX(Year))}>} WEEK))}, Year = {$(=MAX(Year))}>} M_COUNT_WEEK) -
Sum({<WEEK = {$(=Max({<Year={$(=MAX(Year))}>} WEEK - 1))}, Year = {$(=MAX(Year))}>} M_COUNT_WEEK)) /
Sum({<WEEK = {$(=Max({<Year={$(=MAX(Year))}>} WEEK - 1))}, Year = {$(=MAX(Year))}>} M_COUNT_WEEK)
I think that's why you should either use a field which includes week and year or just use date field.
Hi Sunny,
But the thing here is that i have a parameter for week and year
But they are two different fields, I would work with a single WEEK_YEAR field to get this kind of requirement which spans multiple years