AnsweredAssumed Answered

Adding up TimeSheet Time Entries--Missing a Day

Question asked by mtognetti on Jun 1, 2018
Latest reply on Jun 4, 2018 by Tim1302647

Good Day Community,


I am working on a reporting concept where we want to add up time entries by our team members.  I have this written and validate; mostly. 


During my validation I found an anomaly where I am not capturing hours captured on Sunday (the first day of the time period).  I believe I have this issue narrowed down to the TimeSlice.  Looking at both the individual and time week in question, I can see all of this persons entries for the period except those entered on Sunday.  In examining the TimeSlice  table and looking at the prj ids for the elements in this person’s timecard (as below) I find that there is not a timeslice for the day of Sunday, 2 July 2017.  However, as mentioned, every other input for the week on the timecard can be accounted for.


                SELECT *

                   FROM ppm_app.NIKU.PRJ_BLB_SLICES

                  WHERE SLICE_DATE = '2017-07-02' AND PRJ_OBJECT_ID IN (7983034, 7983031,7983040,7983039)


My question to the community is what would cause this?  Is it how we create the timeslicing?  Is it the way we set up our Timesheets?—Sunday is defined as a non-work day.  Is it something else?


I look forward to hearing from the community on this?  If there is additional information I should provide to help us to a solution, please let me know.


Thank you in advance.