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

Logical SQL: How to Calculate Response Percentage

in Reporting and Analytics for HCM 6 comments

Hi Community,

I have BU, ResponseCount and BUTotalCount columns in my Logical SQL based report.

  1. Response Count: It is number of responses from employees on a questionnaire.
  2. Total Headcount of Business Unit: Total number of employees in each business unit.

I need your help to add Response Percentage column

Response Percentage: This should be calculated as (Response Count / Total Headcount of Business Unit) * 100

Question:

How can I modify the Logical SQL report in OTBI to correctly calculate and display the "Response Percentage"?

Below is the screenshot of the report result and at the bottom LOGICAL SQL

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',PREFERRED_CURRENCY='User Preferred Currency 1';SELECT

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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