How to get average years of service by company and gender in OTBI?
Summary:
I need to create an OTBI report to calculate years of service by company and gender.
Content (please ensure you mask any confidential information):
This is my situation:
but I have horrible results (years of service is not so high on average):
I also tried with this formula: Avg("Work Relationship"."# Of Years Service" by "Legal Employer"."Name", "Worker"."Employee Gender")
but the result is the exact same.
What am I doing wrong?
Version (include the version you are using, if applicable):
25B
Code Snippet (add any code snippets that support your topic, if applicable):