Hi, We are building reports on the sn_plng_att_core_resource_assignment table.
One report we aim to create is to answer the following question: What is the distribution of approved FTEs to project and operational work?
However, using the sn_plng_att_core_resource_assignment table, the effort coming from operational resource assignments is not comparable with the effort created through resource assignments on FTE. See the picture below.
This means that our report summing up FTE for project work vs. operational work will give us a too high number for operational work since the effort is presented in hours.
Has anyone circumvented this issue before?
