Hello,
My boss asked to explain why the numbers between the report "Work - between two dates" (from 01/01/2021 until now) and "Detailed work per resource - yearly" (from 2021 january for 12 months) are different and I tried to understand, but I'm not sure if I'm looking into the right place.
For the same resource I get this, on the first report:
And this, on the second one:
I realised that the ticket in green changed from on project to another and on the database I can see that, on the table "work", real work is splitted between the two projects but on the table workelement it is fully attached to one of them (138.01 - B
select prj.id,prj.name, sum(wrk.work)
from work wrk, project prj
where wrk.idproject=prj.id and wrk.refid=2833
group by prj.id,prj.name;
select idproject, idactivity, reftype, refid, refname, realwork
from workelement
where refid=2833;
It seems like the report Detailed Work per Resource - Yearly presents the whole real work of a ticket under the last project it is affected to, but the report work between 2 dates keeps the original project to which the ticket was attached at the moment the work was dispatched.
Is this the right explanation? Is this supposed to work like this?
Thank you for your help on this matter.
Best regards,
MCanuto