Mapping group

Panji

Hi team,

 

I have problem about mapping between entity, entiy(holding) and group.

 

exp: 

entity H have transaction with entity G, but they in a different group (H in group 3, and G in group 2), we can elimination if H and G in a same group, but group 3 and group 2 in the same group 1, so how to create auto mapping using formula based on my case?

 

for detail i attached file

 

Thanks

mapping_75607.xlsx

nathan_rudman

You should have you groups as a hierarchy so you can probably tell that 3 and 2 belong to 1. you can do a LI eliminate:

parent(group entity G) = parent(group entity h)  

that will turn to a TRUE boolean when you can eliminate

 

It's even easier if you have set up a correct entity system module, you can refer directly to the top level of the hierarchy