Level 2 sprint 3 activity 3.3.4 TRA01

I have been trying to figure out the formulas in this activity, I know that YEARVALUE function would be used with LOOKUP function. I am not able to figure out so as to what the mapping dimensions should be for LOOKUP as P3 SKU and G3 Locations are not lists. These are only dimensions I can think of as of now.
Please guide me through this if someone can.

Thanks
Raj

Accepted answers

All comments

shashank30

Hey, could you please upload the screenshot of your query so everyone in the community has a clear picture regarding your doubt and then we can help you in a better way.

Regards,

Shashank

ChrisAHeathcote

@rps98

A few points to help you think through the query and hopefully lead you to the correct solution.

It is not possible to combine YEARVALUE() and LOOKUP() in the same formula
LOOKUP takes a grid dimensioned by the target list and lookups up another dimensions via a line item. This line item must be list formatted.
LOOKUP does not work with text formatted line items as text is meaningless.

Good luck

rps98

Thanks for answering. i was able to construct the formula. I eventually didn't use LOOKUP. Thanks for explaining

Quick Links

Can you help?

Unanswered questions

Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…