Hi,
I have an output from the TS Forecast Factory tool that groups by a field called activity. Each activity forecasts out 90 periods (90 days). The output doesn’t add dates so I’m trying to use a Generate Rows tool to add these future dates to each 90 days of forecasts for each group. The eventual goal will be to add them to the actuals file used in the model.
Example Data:
Activity Period Sub Period Forecasts...
A 1 2 ######
A 1 3 ######
A 1 4 ######
A 1 5 ######
B 1 2 ######
B 1 3 ######
B 1 4 ######
The gist of the formulas are to always take yesterday’s date and generate 90 days forward for each activity and then reset and loop again once it hits the next activity (basically by counting to 90 and then looping). Here is what I have now:
The Generate Tool adds 1 day from yesterday which works but it doesn’t stop at 90. It goes until it errors at 9999-12-31. I think I need help with the Condition Expression on resetting the loop every 90 rows.
What should I change in my generate rows tool to be able to do so? I saw there were some posts about generating rows to fill dates but I didn't see anything that was more related to this post and adding a loop for future dates.
Thanks in advance!
