Lookup from Different Dimension

rachmitadhila · 2024-02-20T03:10:01+00:00

There was an error rendering this rich post.

I have Source Module like below. It has SKU as dimension and line item "Exhibition Year Season" and "Exhibition Year". Both line item are using list formatted data type.

I want to lookup Exhibition Year in Target Module based on Exhibition Year Season in Source Module. So the result of target module will become like this:

I am using formula in Target Module like below:

I_Order Creation.'Exhibition Year' [LOOKUP: I_Order Creation.'Exhibition Year Season']

But it gets error : Format used for lookup doesn't match any dimension of the source.

Do you have suggestion how to resolve this?

Thanks in advance

Accepted answers

All comments

143kishornaidu

Hey @rachmitadhila .

Try Using Firstnonblank or Last nonblank instead of Lookup ['Test 1'.Exhibition Year[FIRSTNONBLANK: 'Test 1'.Exhibition Year Season, FIRSTNONBLANK: 'Test 1'.'Item(SKU)']]

Hope Its Helps

SriNitya

@rachmitadhila
Try using FIRSTNONBLANK
Formula Exhibition Year[FIRSTNONBLANK: 'Exhibition Year Season']

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…