OTBI division operator in calculated column formula is not producing correct results - in Recruiting
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:
1