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.
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 percentage
Thank 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:
Formula could be as
=XLOOKUP( 1, ( tblC[Revenue Type] = [@[Revenue Type]] ) * ( tblC[Outlet] = [@Outlet] ), tblC[Total part] * [@[Total Spend]] * tblC[Comission %] )where tblC is the table with Commission parameters
I'd recommend to use structured tables, not ranges.
Please see in attached.
I am trying to type it in but the outlet, total part, and commission isn't taking. What am i doing wrong?