I am trying to create a query to calculate a sales person commission (flat rate), but only after they reach a certain total. The commission is not effective until the threshold is reach and only applies to dollars over the threshold. I also want to show all the sold units with a column for commission. So the first rows would be empty until the threshold is reached.
Example: Sales of $10,000 the rep receives no commission. Sales of $10,001 rep receives the commission only on the $1.
I sincerely appreciate any suggestions.