Matrix Grid Help

Highlighted
Occasional Contributor

Matrix Grid Help

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!

 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Matrix Grid Help

Hi,

 

if both the lists are identical then try this,

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

 

~VM

Highlighted
Certified Master Anaplanner

Re: Matrix Grid Help

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)))