LOOKUP not working as intended
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