Forum Discussion
Problem calculation total work hours
Hi ceebu
No the table HoursWorked wasn't in the sample. I have several tables not included since it would be a huge task to make af sample of all the tables.:smileyhappy:
The table Hoursworked holds entries per employee per customer they have worked on. So theres many entries per day for the same employee.
You are suggesting to filter using the Hoursworked table, it just can't figure out how - using a join or a function ?
My problem is that it calculates all hours fore all employes in the Employee table. However i only wnat it to calculate on the emplyees who have entries in the Hoursworked table.
You can easily add the Active status of the employee to the filter (visual filter or page filter or report filter) to achieve the desired result.
I added a new table with the Status Fields, and created a few employee records with Inactive status.
Then, I added the Status as a filter in the visual:
See the result with / without the filter.
Download the Updated PBX file here -
Hi ceebu
When i I download the updated file i get my "old" one. No ekstra table etc.
Perhaps you have oploaded the wrong one ?
However filtering using an "Active" field will not do the trick since employees going from Active to Inactive during the year has to be included.
I need to filter/calculate only on the emplyees who have entries in the Hoursworked table. That way they are included whether being Active or not (shiftet status) during the year.
- I guess it would be better if you can share the sample of all your relevant tables and what you would like to accomplish - will make it easier to provide suggestions.
I'm having some troubles with calculating total time for a column. My data has Name, Date, Start time, Finish Time, Lunch break, Total hours work, Total hours (hh"mm), comment. My data came from spreadsheets with stuff worked on them and all I had to do was change time to duration or time and filter out the spreadsheets that I didn't want from a folder and other information. I have a slicer with these filters, Name and Date = relative date is in the last 1 calendar weeks. I have a total hours work Total but I wanted to try a Total hours(hh:mm) Total for the same filter date=relative date is in the las 1 calendar weeks. Is this possible? I just want a simple calculation to add the Total hours (hh:mm) column. So that total should read 20.30 next to the 20.50 total.
Thanks!