Need formula help to offset time period
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?
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.0