Native YTD Calculation issue

Hi,

I have various forecast versions and a prior year version. I want to do a comparison between the selected version and the prior year version. I am finding that the YTD time summary for the prior year version is not taking the YTD as determined by the selected version.

You can see that the YTD calculation for Current Year line item changes based on the version selected but not the Prior Year.

Any guidance would be greatly appreciated!

Accepted answers

All comments

Badam

Hi @kristenr ,

I could see that you have used select for the prior year line item, so irrespective any version dimensions that are there in the model, for all versions it will show the same data from the above formula.

If you need any specific guidance on the above please feel free to reach out to me.

Thanks

Badam

Matasma

vanreign

@kristenr

Hi Kristen,

A few things may help with simplifying this. The Applies to is not presented above so making some assumptions. I am arbitrarily giving the amount name of Revenue $ and renaming these. There are more than one way to do this but this will work:

Current Year Revenue $: Revenue $.Amount[LOOKUP: Time Mgt.Current Year]

Prior Year Revenue $ Revenue $.Amount[LOOKUP: Time Mgt.Prior Year]

(+/-) in Revenue from Prior Year $

(+/-) in Revenue from Prior Year %

Revenue $ Module:

1/22 2/22 3/22…..YTD 1/23 2/23 3/23….YTD

Revenue $

LIS Revenue $ (Revenue $ Module):

Revenue $ X

Time System Module:

Current Year = 2023

Prior Year = Current Year - 1

I hope this helps.

Cheers,

James

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385