selecting TIME period

Hi,

How to select the yearly average value of a line item from a module that is dimensioned by time (monthly), for the current year, in another module that is not dimensioned by time? Please note, I wish to make the formula dynamic and not use static values like TIME.FY19

I have a "Shipments" module that is having monthly scale, time dimension. Line item "ShipmentRatio %" is a percent formatted metric.

I have another module called "Yearly Assumptions", which is not dimensioned by time.

In the Year Assumptions module, I wish to calculate a line item as follows:

CurrentYrAvgRatio = Shipments.ShipmentRatio %[SELECT: TIME.'FY19']

Please note that ShipmentRatio % Summary and Time Summary methods have been set to "Average"

I don't want to hardcode 'FY19'.

Using Shipments.ShipmentRatio %[SELECT: TIME.'Current Period'] is not helping as it is giving me the first MONTH's value from 2019, instead of FY19 average.

How can this be resolved?

Accepted answers

LipChean_Soh

Hi,

You can create 2 line items, i.e.

1. Year Selected with 'Year' as format

2. CurrentYrAvgRatio = Shipments.ShipmentRatio %[LOOKUP: Year Selected]

Thanks,

LipChean

BenHilgendorf

To clarify @LipChean_Soh 's solution, the first line item that he mentioned (which should be added in the Yearly Assumptions module) should have the formula Parent(Time.'Current Period'). This will grab the current year. Then the second line item will use this to lookup the current year's Shipment Ratio average.

All comments

LipChean_Soh

Hi,

You can create 2 line items, i.e.

1. Year Selected with 'Year' as format

2. CurrentYrAvgRatio = Shipments.ShipmentRatio %[LOOKUP: Year Selected]

Thanks,

LipChean

BenHilgendorf

visivasa

This solution works. Thanks!

I had the exact same setup, but what I was missing was PARENT(TIME.Current Period) instead of just TIME.Current Period to calculate SelectedYear. @BenHilgendorf noted that exactly, below

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