Decimal comma/period

User_VMJII

Can I replace the decimal comma with a decimal period so that I get the correct values ​​when exporting to a csv file?

I want the data in excel, but my version does not support export to excel.

On the visualization (first picture), it looks like the decimal separator is a period, but when I export, the decimal separator is a comma, which corrupts my data(second picture) (all values ​​are calculated to two decimal places).

Sumanth V -Oracle

@User_VMJII - Could you please confirm whether you are using Oracle Analytics Cloud (OAC) or Oracle Analytics Server (OAS) for the current issue? If you are using OAS, kindly include the version details to help us better assist you.

Thank you.

User_VMJII

I am using OAS:

SteveF-Oracle

This should be based on your browser locale.
Test the solution documented here;

How To Set The Locale To Spanish (Mexico) vs Spanish (Spain) In DV (Doc ID 2968100.1)

RichardChan

In the criteria tab of your analysis:

1. Click the fact column and select "Column Properties"
2. Click on "Data Format"
3. Check "Override Default Data Format" box
4. Specify decimal places and 1000s separator
5. If you want this format to be applied to all the ocurrences of this fact column (and assuming you have the privileges) you can save this format as system-wide default by clicking "Save as default

User_VMJII

@RichardChan thanks for the reply. Did you mean here?

Because I can't find the section to follow your instructions.