Need formula help to offset time period

niti
Occasional Contributor

Need formula help to offset time period

Hi all,

I am having some trouble determining how to combine certain time functions. I am trying to forecast sales with an associated start date and end date. The attached shows what I'm trying to accomplish. I've tried offset but I can't use that with a time period.  Is there another way to offset a time period?

Thanks!

1 REPLY 1
obriegr
Certified Master Anaplanner

Re: Need formula help to offset time period

@niti 

There are a few ways to handle this, but I have found most successful to have a child list that handles all of the entries data. 

I would then take the values that are entered and push them to a time dimensioned module (same level), with the equation essentially saying if Current Period() >= Data Module.Start Period AND Current Period() < Data Module.End Period THEN Data Module.Sales ELSE 0

I would then take the parent level information into the reporting module, for the total sales.