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
