I have a monthly analysis for each employee but the conbdition is I need to add 1 to every friday if the total workinmg hours in week is >60.
If the week falls in same month then there is no problem with the expression but if the week falls in two month, then I need to add 1 to Friday.
Let us take an example
EMPL_ID
Date
Hours worked
1001
3/28/2011
12
1001
3/29/2011
14
1001
3/30/2011
9
1001
3/31/2011
10
1001
4/1/2011
16
1001
4/2/2011
0
1001
4/3/2011
0
My Output should be (no. of days worked)
EMPL_ID/Month
Mar
Apr
1001
4
2
Here as the employee worked morethan 60 days in a week and week is deviding in two months, then I need to add one extra day to him (i.e on Friday only)
Please help either through script or Expression level.
