Level 1: Anaplan cannot see "dot" as decimal separator

Fanny
Occasional Contributor

Level 1: Anaplan cannot see "dot" as decimal separator

Hi everyone, 

I don't know if someone encounters the same problem as me: whenever I import data containing dot as decimal separator into anaplan, it does not recognise the dot and include the decimal party in the absolute value. For example, this is the value imported

 

Fanny_2-1627303442709.png

 

And this is the value affiched: 

 

Fanny_1-1627303404357.png

Here's the format number, decimal point is already "dot".

 

Fanny_3-1627303588837.png

Does anyone knows how to correct it? Please help. Many thanks. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Level 1: Anaplan cannot see "dot" as decimal separator

@Fanny 

You're so close. Kudos for finding the formatting screen! When we import the data you'll be presented with a slightly different screen that allows you to designate the decimal place. Here's a screenshot. Try importing the data again but this time check the decimal place.

DecimalPlace.png


Jared Dolich

View solution in original post

2 REPLIES 2
JaredDolich
Moderator

Re: Level 1: Anaplan cannot see "dot" as decimal separator

@Fanny 

You're so close. Kudos for finding the formatting screen! When we import the data you'll be presented with a slightly different screen that allows you to designate the decimal place. Here's a screenshot. Try importing the data again but this time check the decimal place.

DecimalPlace.png


Jared Dolich

View solution in original post

Fanny
Occasional Contributor

Re: Level 1: Anaplan cannot see "dot" as decimal separator

Thanks a lot JaredDolich for your quick reply. You are adorable.