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

How to use the average functionality per legal employer?

Received Response


Trying to use th avg functionality in OTBI but not getting the right results in

Content (required):

I want to show some simple statistics based on legal employers in our HCM setup. I am starting with a simple task, showing the average years of service for assignments in each legal employer.

I have just the two columns: Legal employer name and years of service. In screenshot 1 it shows the total years of service for each legal employer, because I haven't added any filter or formula, which isn't the requirement.

Then I tried adding the avg formula to the Years of service column in screenshot two. This however results in what I'm guessing is the average years of service for the entire enterprise to be shown for each legal employer row (screenshot 3).


Howdy, Stranger!

Log In

To view full details, sign in.


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