Forum Discussion
db_pdx
Valued Contributor
Hi Carlos_S: maybe the missing piece is that parameters you might need? I'm not sure how your UD4 fits in, but the solution Christian proposed is exactly what we use and it works great.
To help reinforce his proposal, here is how we implemented it:
- A parameter in the Fixed POV that prompts a user to select the 'Month-End Close Period'
- Two columns in the layout section: one which provides all trailing year actuals, one that provides all future period forecast
- The T#[].AllPriorInYearInclusive and T#[].AllNextInYear is the secret sauce that makes it dynamic
Here are our components (very similar to what Christian listed):
And here is what it looks like what a user makes a selection for 'Month-End Close Period' (our |!Select_Time_Close!|)
When selecting 2022M5
When selecting 2022M6
You'll notice how the periods (and formatting) dynamically move with the time period selection. Hope this helps and would encourage that you give ChristianW proposal a try. Cheers! -db
Carlos_S
3 years agoNew Contributor
Thank you, I'll give it a try.
Related Content
- 11 months ago
- 2 years ago