Complex Sales Goals

[SergioGG86]

Hello friends,

Im trying to find out the bonus for each employee given the following conditions. In table Store I have the sum of sales which is Store[Total Sales]. So lets supponse we get that Employee Mark adds up $2801 this month, his bonus will be 2801*5%. Beware that these goals can change any given month.

Date Person Product Store Sale

1/2/2022 Harry 87 A $987.00

1/2/2022 Mark 897 A $987.00

1/2/2022 Rebeca 87a B $987.00

1/2/2022 Caroline 98 D $987.00

2/2/2022 Harry 87 A $1387.00

Goals Table:

Date Goal Store Sale_Goal Bonus

01/01/2022	Goal 1	A	$3,400	3 %
01/01/2022	Goal 2	A	$3,672	5 %
01/01/2022	Goal 3	A	$4,080	7 %
01/01/2022	Goal 1	B	$2,500	3 %
01/01/2022	Goal 2	B	$2,700	5 %
01/01/2022	Goal 3	B	$3,000	7 %
01/01/2022	Goal 1	C	$8,000	5 %
01/01/2022	Goal 2	C	$8,640	6 %
01/01/2022	Goal 3	C	$9,600	7 %
01/01/2022	Goal 1	D	$2,500	3 %
01/01/2022	Goal 2	D	$2,700	5 %
01/01/2022	Goal 3	D	$3,000	7 %
01/01/2022	Goal 1	E	$4,000	3 %
01/01/2022	Goal 2	E	$4,320	5 %
01/01/2022	Goal 3	E	$4,800	7 %

Thankyou

[Anonymous]

Hi @SergioGG86 ,

Sorry, not very clear. Could you please tell in more detail what is the Goals Table for?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.