Forum Discussion
Complex Sales Goals
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
1 Reply
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.
