Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Current year + 2 as filter in column — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Current year + 2 as filter in column

Received Response
11
Views
2
Comments

Summary:


Content (required):

Hi

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!