Forecast imply that the Start date is now and the End date is in the future.
How do you automate a report where the End date is in the future?
Forecast imply that the Start date is now and the End date is in the future.
How do you automate a report where the End date is in the future?
Hi,
This can be done using the “Calculating Time Period” option in reporting objects, where a timestamp in the future is calculated in an Expression object. The report generation frequency is set up in the report settings. I have attached few screen shots to help explain the process.
Report generation timestamp object:
Another time object, as the above doesn’t appear on table time definition. It basically refers to above time without any expression, this is the end time
Start time object:
Table Example:
