Is it possible to insert a variable into the Filter function that represents the Active Forecast?
I have recently setup the Forecast module so that is is running weekly, and it has run at least 4 times. I am reviewing the Forecasting Analytics Functional Overview for R17 webinar that is available on the Training and Support site and I have built the exact report that is shown there. Part of building this report is to use the Filter function on the Forecast Revenue column like this: FILTER("Forecast Metrics"."Forecast Revenue" USING ("Forecast Date".Date = date '2013-03-18'))
How can I insert a variable into this function that will give me the most recent Forecast date so that this doesn't have to be changed manually each week? The Forecast is scheduled to run every Monday, so is it possible to insert something that calculates Monday's date of the current week? I tried filtering by Forecast Status = Active, but that didn't work. Is this supported?