I need to calculate the commission

[#1]

Hello,

I have two tables, Agent Invoices and Agent percentage of commission.

in the graph i have the agent, year, gross margen average, total invoices, comission % and comission $$$.

I need to calculate  the comission depending of gross margen average for every agent.

see included file

Please help me

Regards

Fernan