Prior Year Value: Page selector?

How can I view the actuals for a previous year, regardless of the current year? For example, if if July 2023 is selected, I want to see the full year 2022 actuals. Similarly, if July 2024 is selected, I want to see the full year actuals of 2023.

My current logic is only working for 2022 actuals.

Actuals = Amount [Lookup: 'ADMIN - Time Selection'.PY]]

Accepted answers

Konstantin97

Hi @ashasli!

In this case you can create another line item for lookup, let's name it "Previous full year", it should apply to months and have a "Year" format. Write down the formula "Parent(Parent(Item(time))) - 1", so for every month it should show you the value of previous full year.

Formula in line item should look like this and also line item should apply to months

Actuals = Amount [Lookup: …..Previous full year]]

So you will get Full previous year value in every month, I also recommend you to set "average" time summary to get the right value for Qs and FYs

Thanks,

Konstantin

All comments

Konstantin97

Hi @ashasli!

Formula in line item should look like this and also line item should apply to months

Actuals = Amount [Lookup: …..Previous full year]]

So you will get Full previous year value in every month, I also recommend you to set "average" time summary to get the right value for Qs and FYs

Thanks,

Konstantin

ashasli

@Konstantin97 thank you it worked!

unknown

This content has been removed.

Quick Links

Can you help?

Unanswered questions

UX Filter
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?