Lookup off of code

Options
KevinMcQuillen
KevinMcQuillen Member, ALL USERS, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner
in Planning & Modeling

I need to be able to lookup off a unique opportunity code for line items in a module.  

Below is the code I need to look up off of, the list is titled MEC Opportunities

KevinMcQuillen_0-1618953085451.png

In this module, I need the line item Opportunity Code (list) to return the above codes while also being list formatted in order to use in lookup functions.

KevinMcQuillen_1-1618953427885.png

My train of thought is FINDITEM(Code(Item('MEC Opportunities')), Opportunity Name) however this has not been working.

Any help/corrections would be greatly appreciated, thanks!

 

Tagged:

Comments

  • KevinMcQuillen
    KevinMcQuillen Member, ALL USERS, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

     

    This still does not return the code, however - it returns the list item names per below

    KevinMcQuillen_0-1619011328860.png

    KevinMcQuillen_1-1619011610934.png

    I need the line item to be returning the unique codes from the list - while also keeping the line item list-formatted so that may utilize LOOKUP formulas off of the Code.

    KevinMcQuillen_2-1619011731701.png

    Is this functionality possible?

     

     

     

  • KevinMcQuillen
    KevinMcQuillen Member, ALL USERS, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    Sorry I don't think I'm explaining this well.

    The core of the issue is this - Management has requested a dashboard view of a list - 'MEC Opportunities' - which is  a specific set of opportunities with very specific naming conventions, therefore in the list I must use a display name.  This used to be a subset of a larger list titled - 'All Opportunities' - however given managements request on how they want to view the Grid, I need a new list with the correct Display Name.  There is a filter in a properties module which can be checked if an opportunity qualifies as MEC.  I used a saved view with the MEC filter applied to create the 'MEC Opportunities' list.

    Then in the module, I have various line items which require a LOOKUP formula.  The module is dimensionalized by the 'MEC Opportunities' list.  In various other modules, I create an 'All Opportunities' list formatted line item which I then use for the LOOKUP functions, per below...

    KevinMcQuillen_0-1619014327402.png

    This example above is a module in which the functionality is working.  Below is the module I am seeking help on, b/c the same process is not working.

    KevinMcQuillen_1-1619014449460.png

    For the "SalesReq" and "Opportunity URL" line items, when I try to LOOKUP on the "Opportunity (list)"  - 'Properties: All Opportunities'.SalesReq[LOOKUP: 'Opportunity (list)'] - I get a mapping error.  My thought was that this is because of the different display name, the MEC Opportunities List and the All Opportunities list are un-able to match.  Therefore I was hoping to be able to LOOKUP on the code, however as you mention that is impossible.

    So yes, creating a text-formatted line-item with the code is simple to do, but it does not exactly accomplish what I am needing.

    Do you have any other work-arounds you can think of for this situation?

    Thanks for all the help, it is much appreciated!

Categories