Hi there, i have a problem here
I need to do up a report for Staff alertness
The report is to show how much each team will get by the end of the month.
If they meet the criteria to perform well, each member in that team will get $10 for the 1st month(eg Oct).
If the next month(eg Nov) they did well too, the money will roll and each will get $15 for Nov.
For the 3rd month (eg Dec) and above they will get $20 each
However the money will only add on if they have staff alertness for a consecutive period of 3 months and above.
If for example they failed to perform well, they will get nothing for that month, and next month they have to start from only $10 dollars again.
Any help is appreciated.
I need to do up a report for Staff alertness
The report is to show how much each team will get by the end of the month.
If they meet the criteria to perform well, each member in that team will get $10 for the 1st month(eg Oct).
If the next month(eg Nov) they did well too, the money will roll and each will get $15 for Nov.
For the 3rd month (eg Dec) and above they will get $20 each
However the money will only add on if they have staff alertness for a consecutive period of 3 months and above.
If for example they failed to perform well, they will get nothing for that month, and next month they have to start from only $10 dollars again.
Any help is appreciated.
