My Oracle Support Banner

RPAS Fusion Client: Exporting as Formatted Exports Percentage Measures with an Extra '0' Before the '%' Symbol (Doc ID 2367206.1)

Last updated on MAY 27, 2020

Applies to:

Oracle Retail Predictive Application Server - Version 16.0.1 and later
Information in this document applies to any platform.


In Oracle Retail Predictive Application Server (RPAS) Fusion Client (FC), when a worksheet that contains measures formatted as percentage is exported to Excel with 'Formatted' as the export format type, an extra '0' is added after the decimal before the '%' symbol.

Steps to Recreate:
1. Create a new workbook that contains measures formatted as percentage.
2. Check the percentage measure format details;
3. Notice that the measure should be displayed in the FC as '100.0%' for example.
4. File -> Export.
5. Select the following;
Export To: Excel
Export Format Type: Formatted
6. Press Ok, and open the exported excel sheet.
Notice that the measure is displayed as '100.00%'.




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

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

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