My Oracle Support Banner

OBI: Calculated Field Displays Incorrect Total When Using Double Numeric Type (Doc ID 2444633.1)

Last updated on JUNE 02, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and later
Oracle Analytics Cloud - Classic - Version 17.4.1 and later
Information in this document applies to any platform.

Symptoms

Incorrect results appear on a calculated field, for example:

 

Sales + Tax - Payments = Amount Owed

89.1 + 10.9 - 100.0 = 0.00000000014

The expected result is zero (0).

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.