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?



  • @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.