topic Re: Calculate salesbonus based on max bonus value in App Development

Calculate salesbonus based on max bonus value

Anonymous — Mon, 23 Oct 2017 12:29:12 GMT

Hi,

I am trying to create an app that calculates salesbonus for our Salespersons. It works in steps so items between 1-10 give 100, between 10-20 200 and so on until 500 is reached. But the problem is that it works backwards, so if you have reached 20 the amount is 200 for every item sold, also items between 1-10 etc. So I need to find a way that finds the max value of bonus amount and applies to all former items sold.

SalesStaff	SalesDate	Max(QtySumInsurance)	Max(BonusAmt)
BBK	10/2/2017 0:00	6	100
BBK	10/3/2017 0:00	11	150
BBK	10/4/2017 0:00	16	150
BBK	10/5/2017 0:00	22	200
BBK	10/6/2017 0:00	30	200
BBK	10/9/2017 0:00	36	250
BBK	10/10/2017 0:00	38	250
BBK	10/11/2017 0:00	42	300
BBK	10/12/2017 0:00	47	300
BBK	10/13/2017 0:00	56	350
BBK	10/14/2017 0:00	55	350
BBK	10/16/2017 0:00	59	350
BBK	10/17/2017 0:00	61	400
BBK	10/18/2017 0:00	65	400
BBK	10/19/2017 0:00	69	400

So in this example 400 is the maximum and I would like to be able to use that as a multiplier for items back in time or for example for 10/2/2017 I would calculate 6*400 = 2400.

Any ideas on how to solve this?

Regards

Birkir

Re: Calculate salesbonus based on max bonus value

sunny_talwar — Mon, 23 Oct 2017 12:33:35 GMT

May be this

Max(TOTAL <SalesStaff> BonusAmt)

Re: Calculate salesbonus based on max bonus value

MarcoARaymundo — Mon, 23 Oct 2017 12:42:11 GMT

Is the Bonus calculated by the amount per sale or by the accumulated amount of a given period?

Re: Calculate salesbonus based on max bonus value

Anonymous — Mon, 23 Oct 2017 20:54:16 GMT

Sunny

Thanks for this, it works. I forgot one thing, on the first day of each month the accumulative number or QtySumInsurance should return to 0, I would handle that in the load any idea?

Re: Calculate salesbonus based on max bonus value

Anonymous — Mon, 23 Oct 2017 20:56:00 GMT

Hi ,

Marco the bonus works by the number of item sold, so if you sell between 1-10 you get 100 for each,10-20 200 and so on. But each month the accumulative qty should return to 0 , I have not solved that.

Re: Calculate salesbonus based on max bonus value

sunny_talwar — Tue, 24 Oct 2017 00:19:20 GMT

Return to zero or are you looking for Max by each month?