Multiple assignment abse
Summary:
Hi,
I am trying to create a report for absences that are assigned at assignment level. As you can see from the image attached the moment a column is added from the assignment level, it multiplies the rows as all absence entries are against them. So the total duration should be 7 not 21. The occurances is working as expected(OOTB metric used) as I believe its using the person id to count that.
Has anyone produced such a report that correctly counts duration without summing the same absence?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):