Comparing list items (formula help)

Options
obernardini
obernardini Member, ALL USERS Posts: 3 New Contributor
in Planning & Modeling

I am trying to see if items I have in one list exist in the other. I have created a module with a boolean line item and my idea was to use the formula = IF ISNOTBLANK(FIND('IN3 Vehicle'.anacode, Total Vehicles.anacode)) THEN TRUE ELSE FALSE to find if the values exist in both list. (If it does appear in both list return true) The list items are formatted as numbers. What formula should I use that can allow me to compare the two list without having to line up the list values?  (note: i am having a hard time using FINDITEM as well because they do not have a hierarchical relationship)

 

Thank You!

Tagged:

Comments

  • obernardini
    obernardini Member, ALL USERS Posts: 3 New Contributor

    Hi,

     

    Thank you so much for your help!

     

    When I try to run NAME(ITEM(X)) it returns: "not recognized as a hierarchy in the model. The ITEM function should take a hierarchy as argument"

     
    How should I fix this?

Categories