Forum Discussion
Calculate Commission from a Range table
I want to calculate commission for each employee from a range table (pls. refer below). Example - If Person A's total sales amount is 1500, then the measure should give output of 80 ( 5% for 1000 = 5...
Thank you for a quick response. Sorry I forgot to give complete details. Below is a screenshot of the data model.
tblTargets includes Targets range and commission for each sales person by financial year.
tblBase contains monthly sales amount by sales person.
Sales person list changes very often with new person getting added. tblSales also gets updated with every month with sales data for the month.