4 Replies Latest reply on Sep 8, 2013 12:52 AM by Steve Martin

# Duplicate time periods between parameter groups

So, not sure if this is possible but would love it to work properly.  I have a workbook where I want the user to be able to pick their time periods.  When they pick their time periods the workbook automatically makes a LY and TY.  The only problem is that if the time period is more than 13 periods I am not able to overlap the timeperiods into both LY and TY.  There are 13 periods each year.  So for instance if they choose time period 1 2012/03 thru 2013/07 then that would become TY and LY should be 2011/03 thru 2012/07 but that doesn't happen.  LY stops at 2012/02.  Is there anyway I can get around this?

Workbook attached.

• ###### 1. Re: Duplicate time periods between parameter groups

I guess I need to reply to my own question to push it back to the top.  Anyone able to help me here?

• ###### 2. Re: Duplicate time periods between parameter groups

Hi Tom, I think I may be missing the point here (maybe being a bit daft) as reading your problem it almost looks as though you want to be selecting period of one year less than those that have been selected as the two time period parameters; please can you clarify for me.

• ###### 3. Re: Duplicate time periods between parameter groups

Yeah let me see if I can explain it in a way that makes sense (not easy for me!).  So I have data ranging in periods from 2010/07 through 2013/07.  I want them to be able to select any beginning and end period and have "LY" be exactly a year less than the period they selected.  So say period 1 is 2012/01 then in the calcs TY would start with 2012/01 and LY would start with 2011/01.  But then say for period 2 they choose 2013/03 then TY would end 2013/03 but LY won't overlap periods so it ends in 2012/01 instead of 2012/03.  I need LY to pick up those last periods.

Does that make any sense at all?

• ###### 4. Re: Duplicate time periods between parameter groups

Hi Tom, apologies I've been away. Did you ever manage to solve this? I can fully appreciate your frustration, I can continue looking at it but I have just dropped a message to Jonathan Drummey as he is very good and he may be able to answer this straight away.