I have problem about mapping between entity, entiy(holding) and group.
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
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 hierarchy0