Forum Discussion
Value between days
Hi ubg ,
Not very clear, if convenient, you can elaborate on how this final number of hours is derived from, we can better help you.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, thank you very much for your reply.
I present the situation again in a different way.
Between 07/01/2023 and 01/04/2023 two employees have posted working hours on two positions of the project.
In total 128 hours.
The result in the matrix visuals is displayed correctly.
The project manager irregularly estimates the progress of performance in the project.
The day of the estimation is saved in the "PERF" table.
I now need in the report the number of hours between the data of the perf table.
In the example the days for position 1 until 28.01.2023 and from 29.01.2023 to 28.02.2023.
For position 2 until 01/25/2023 , from 01/26/2023 to 02/20/2023 and from 02/21/2023 to 03/29/2023.
This would be the result:
Hours after the last PERF entry should not be displayed.