We are building Sales App.
We have column that shows total amount of sales in typical month. Example oct 2020
We want to add new column with Commission Percentage which work on following logic
If total sales 0 to 100,000 then value is 10
If total sales lie between 100,001 to 200,000 then value is 12
If total sales lie between 200,001 to 300,000 then value is 13
and so on…
Kindly guide how to do that