Matrix Grid Help

CommunityMember113484
CommunityMember113484
in Modeling

Hi,

I currently have 2 entity lists (identical), and a module which maps the entity 1 list to entity 2 list. What I'm trying to do is to create a matrix with entity 1 as rows, and entity 2 in the columns (i.e. an entity matrix).

1. How do I create a formula which states if Entity in row = Entity in the column, select boolean?

Thanks!

 

Tagged:

Best Answer

  • VIGNESH.M
    VIGNESH.M
    Answer ✓

    Hi,

     

    if both the lists are identical then try this,

    NAME(ITEM('ENTITY LIST1')) = NAME(ITEM('ENTITY LIST 2'))

     

    ~VM

Comments

  • sean_culligan
    sean_culligan

    There is another potential solution to this requirement. If you had a module which is dimensioned by Entity 1 and you wanted to find all the corresponding Entity 2 records (or vice versa), you could do this using the finditem function.

     

    In your entity 1 module you would add a line item which is list formatted as Entity 2. Then use the formula:

     

    Finditem(Entity 2, Name(Item(Entity 1)))

     

     

     

Categories