Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

showing a historical assignment as latest for some employees

in Reporting and Analytics for ERP 3 comments

Summary:

We have an issue where the top (or Max) row is not returning the correct row! Instead of returning the current assignment, it is returning an old assignment for few employees. When I added an RCOUNT column (RCOUNT(1 by Person Number), it was clear that the row with max number is pointing to an older inactive assignment!

This issue is causing the employee record to falloff our Employees reports!

Content (please ensure you mask any confidential information):

  • Person (3) in attached screenshot! His current (Max) assignment is E224674-2, but the MAX Rcount is actually pointing to Assignment (P224674)
  • Persons 1 and 2 are provided as an example of the rest of the population and are reflecting the correct RCOUNT/ Order
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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