Current year + 2 as filter in column
I would like to show the forecast for 2 years from now for a specific column.
For example in the code below I've used a repository variable called NEXT_YEAR which shows the forecast for 2023:
IFNULL(FILTER("- Current Forecast"."Current EAC Cost" USING (("Time"."Calendar Year" = VALUEOF("NEXT_YEAR")) AND (("Project Forecast Version"."Forecast Status Code" = 'CA') OR ("Project Forecast Version"."Forecast Status Code" = 'COA')))),0)
How ever I also need to be fixed for 2023. So is there a way that I can do this? Under the column I clik Edit Forumula --> Filter:
Then I use the Time folder and Year: