Lookup error : invalid lookup list X is unused

RitaD

Hi guys,

I am facing an error for the first time and I was wondering if anyone had an idea on how to get throught it

For some context I have :

LI1 reference dimensionned by "Dimension A" format number

LI2 target dimensionned by "Dimension B" format number

LI3 dimensionned by "Dimension A" format "dimension B" (a basic lookup situation)

so my formula is LI1[LOOKUP:LI3] but this time it does not seem to work.

Thank you in advance

Accepted answers

All comments

KUMARNR

Hi @RitaD it seems you have created the mapping in Dimension A module.

When you are looking up the values, the Target module and the Mapping module should have the same dimension.

For you to get answer, in LI3 Keep the dimension B and Line-item format Dimension A and formula Parent (Dimension B)

And lookup LI1[LOOKUP:LI3].

Hope this help!

TheresaR

@RitaD are you working in Polaris? There is a difference in the way Polaris treats lookups when using subsets compared to how it functions in the Classic engine. See the Anapedia documentation for reference:

Calculation function differences between engines | Anapedia

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
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.…