OTBI division operator in calculated column formula is not producing correct results - in Recruiting — Cloud Customer Connect
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

OTBI division operator in calculated column formula is not producing correct results - in Recruiting

edited Apr 26, 2021 7:41PM in Reporting and Analytics for HCM 5 comments

Summary

The division operator in a calculated formula is not producing correct results in the Recruiting - Recruiting Events Real Time subject area.

Content

In OTBI, when using the division operator in a calculated column formula the correct results are not being displayed (using Recruiting - Recruiting Events Real Time subject area).

Here is the formula:

ROUND(("Job Application History - Event"."Number of Job Offer changed to Accepted State" / "Job Application History - Event"."Number of Job Applications"),2) * 100

The XML and results are attached.

Thank you for your help,

MaryAnn

 

 

 

Version

OBIEE 11.1.1.9
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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