Prior Year on Weekly Module
Hi All, Thought I would post this question... I'm working on a model with a weekly timescale. (13 4Week periods) Normally there is 52 weeks in a year, but every few years there will be a 53rd week. I was planning to use a LAG() function to pull the PY value. Offset would work too.
LAG( Source Line Item, 52 , 0 )
I have to hard code 52 into the formula, so not sure what will happen in 53 week years. Any ever looked at this in the past. I am going to look into it today so will post a solution if I find one. Thanks, Simon