Problem with decimal separator when importing

TomasGomezVilla

Hello! 

 

I have a very small issue when importing a .csv file into my model. I have designated 'comma' as my decimal separator, but Anaplan changes it to a point for certain data entries after doing the import, despite only having the comma as the decimal separator in the import preview . I am adding a couple of screenshots to better illustrate this.

 

Do you know why this is so? What am I missing?

 

Thanks a lot in advance!

 

Tomas

KirillKuznetsov

Hi @TomasGomezVilla 

Please try to change Number format settings of the desired line item.

You can select Decimal symbol there.

 

TomasGomezVilla

@KirillKuznetsov 

Thanks a lot for the help! 

 

Unfortunately it doesn't seem to have changed my data, even after purging and recharging it. Do you have any additional tips? 

 

 

KirillKuznetsov

@TomasGomezVilla 

Please check selected decimal in import data source setting:

 

TomasGomezVilla

Thanks once again!

I had to specify that my data had no thousands separator.

Thanks!