Forum Discussion
Split Weekly Payroll Numbers into Daily Amounts
- 7 years ago
Employee Start Date End Date Check Date Amount
John Doe 11/5/2018 11/11/2018 11/16/2018 $11,000.00
Bill White 11/5/2018 11/11/2018 11/16/2018 $5,500.00
Desired Result
Employee Date DayOfWeek Amount
John Doe 11/5/2018 Mon $2,000.00
John Doe 11/6/2018 Tue $2,000.00
John Doe 11/7/2018 Wed $2,000.00
John Doe 11/8/2018 Thu $2,000.00
John Doe 11/9/2018 Fri $2,000.00
John Doe 11/10/2018 Sat $1,000.00
John Doe 11/11/2018 Sun $ 0.00
Bill White 11/5/2018 Mon $1,000.00
Bill White 11/6/2018 Tue $1,000.00
Bill White 11/7/2018 Wed $1,000.00
Bill White 11/8/2018 Thu $1,000.00
Bill White 11/9/2018 Fri $1,000.00
Bill White 11/10/2018 Sat $ 500.00
Bill White 11/11/2018 Sun $ 0.00
- Eric7 years agoAdvocate I
Awesome! Thanks Ashish, thus is exactly what I've been looking for.
- Ashish_Mathur7 years agoSuper User
You are welcome.