Forum Discussion
Problem calculation total work hours
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.