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 calculate percentage of Employees with more than 5 hours of learning?

Received Response


I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have:

  • a counter for employee names to get the total number of employees
  • a calculated column that sums the total hours of actual effort per employee
  • a calculated column that evaluates to 1 if total actual effort is higher than 5 or 0 if less

Do you have any ideas? I tried to SUM the second calculated column "SUM(CASE WHEN SUM("Completion Information"."Total Actual Effort" BY "Assigned to Information"."Assignee Display Name")>5 THEN 1 ELSE 0 END)", but seems like the nested aggregation is a bit of a problem and fails to produce the correct result.

Howdy, Stranger!

Log In

To view full details, sign in.


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