Need Help -Comission

[qwaiti27231]

Below table is main establish table . which has comission rates 

est connection separate

need to find comission amount for each establishment

est connection
est id	order no
1	2
2	3
3	4
4	1
5	6
6	5

order no	amount
1	10
2	15
3	20
4	25
5	30
6	35

Est_ab	commission	Est id
a	10	1
b	12	2
c	10	3
d	10	4
E	12	5
f	10	6

[dramus]

Try adding this column to the orders table.

Commission Amount = [amount] * LOOKUPVALUE(Commissions[commission],Commissions[Est id],RELATED(Establishments[est id]))/100

[qwaiti27231]

@dramus It didnt work . they are three tables 1.Connection table 2.Order table 3.Est table Comission of each est name has to be founded with given commission rate