My Oracle Support Banner

Why Is UI Value In Integer While Exported Value in Excel Is In Decimals? (Doc ID 2420026.1)

Last updated on OCTOBER 23, 2019

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOUR

In the UI value of a calculated measure is in integers whereas after exporting the same the value in Excel is in decimals.


STEPS TO REPRODUCE

1. Open a Plan
2. Open A Table (Eg Forecast Analysis)
3. View the value of measure 'Shipments Forecast' as 200
4. Export the table to Excel.

Notice that the value in the Excel is 199.9999

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
References


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