Forum Discussion
Commission Calculation totals
I should just confirm that your output table is an Excel Table (with or without the jolly stripes). The fact that your field names comprise multiple words makes the syntax slightly more complex, but it should come up correctly simply by clicking the target cell.
= LOOKUP( 1, 1 / ( tblC3[Revenue Type] = [@[Revenue Type]]) / ( tblC3[Outlet] = [@Outlet]), tblC3[Total part] * [@[Total spend]] * tblC3[Commission %] )The thing to note that if an additional square bracket appears, it should have a corresponding closing bracket.
From the sample it's not clear how Commission depends on Outlet type. Do you have any formal logic?
- Hi Sergei,
yes so depending on the rev type and outlet depends on the commission percentage. Below is the breakdown
Revenue Type Outlet Comission % Comments
New to TV WDSU 20%
New Business WDSU 15%
Direct WDSU 13%
Agency WDSU ((.85*total)*(.06)) Formula to get to the percentage
New Business MeTV 20%
Direct MeTV 13%
New Agency MeTV ((.85*total)*(.10)) Formula to get to the percentage
Agency ((.85*total)*(.6)) Formula to get to the percentage
Digital (total8*06) Formula to get to the percentageThank you.
- If Outlet is missed does that mean formula is for any Outlet?
- What is the latest formula?
This is more basic (with filled in outlets)
This is what I wish to calculate if you would be able to help with this it would be preferable:
Your formulas have the same structure. I'd add one more column to do all calculations in one form.
However, back to your initial sample I don't see such combinations in commissions table.
