RPAS Fusion Client: Exporting as Formatted Exports Percentage Measures with an Extra '0' Before the '%' Symbol

(Doc ID 2367206.1)

Last updated on MARCH 12, 2018

Applies to:

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

Symptoms

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;
Suffix:%
Precision:1
Scale:0.01
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%'.

Changes

 

Cause

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 hundreds of Community platforms