LOOKUP not working as intended

Hi Anaplaners,

I'm having an issue with IF ELSE Statement. I expect the ‘ELSE’ part to go accross opposite direction than the ‘IF’ condition. But it seems to not be working using a LOOKUP function but works with a SELECT function.

I want to promote it to PROD but I can't do it with using a SELECT BUT INSTEAD A LOOKUP.

Please I will need your advice on how to go about it. Or why does SELECT work differently than the LOOKUP.

Below is a screen shot to demonstrate.

The SELECT goes past 'Month36' which is what I want

2. The LOOKUP matches ONLY the 'Month 36' and don't move on accross with the ELSE condition

Below is the module dimension

And the LOOKUP drop down SYS Module named TEST

Accepted answers

All comments

HimanshuRaj

Hi @innocent

You can perform below steps to achieve your result via lookup:

In the “Lookup %” formula, the IF part is only recognising if “Month 1, 2, 3 & 4” then pick same values as in input and else part is picking up only “Month 4” value , i.e 1% via lookup
Use system module, make one list formatted line item to select “Month 4” in my case, and then in “Month 5 %” line item use this formula to pick the value, which you can refer in the else part in 1st module

Hope, this resolves your issue. Cheers!!

Monpero

Thanks @Himanshu1998 for the workaround. I have it resolved using a different method where I assigned the 'month 36' to a line item with month number list as the dimension and then did a lookup on the line item and it got it across.

andrewtye

Hi - as a further point as the dimensions are very different would for best practice look to separate them out into separate modules. You might also find that the lookup works as intended. Also because of the multiple dimensions as you've found need to ensure that it works as expected at the top level for the other lists.

Quick Links

Can you help?

Unanswered questions

ERROR 16020 |-- Anaplan API: Invalid key path
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…