Multiple assignment abse — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!