I have 2 metrics in my dataset: Actuals and Forecast. Actuals show what has already happened and Forecast is what we predict we will spend in the future.
My fiscal year starts in September(Month 1, 1st Quarter) and Ends in August(Month 12, 4th Quarter). that is in the Master Calendar Script.
This is a month-end dataset, so we are currently in September, the dashboard should show Actual data for August. Since September hasn't ended yet, Actuals for September will be $0
But Forecast data can be shown for any future months.
I need to calculate the current month-end's actuals, and the current quarter's actuals using Set Analysis Expression.
The current month-end would be the actuals for the month of August.
The current quarter would be the actuals for the 4th Quarter Q4.
But I cannot just do vMax_Month-1, because what if I am in the 1st month of the fiscal year, then my previous month will be based on a value of '0'.
