Register

Trouble importing BookPrice

Sanaa
New Contributor

Trouble importing BookPrice

Hello, 

 

I am having troubles when I import the data from the Price Book that I downloaded from Anaplan Learning. 

The numbers imported are inserted with a multiplication of 100 (e.g 0.84 USD ==> 84 USD), so my margin calculation is all false! 

 

What should I do ? 

PS : I have applied the same Format for the line items as indicated in the training support. 

 

Thank you, 

4 REPLIES 4
ben_speight
Super Contributor

Re: Trouble importing BookPrice

Check the decimal separator (dot or comma) is correct in the import data source (File options).

Sanaa
New Contributor

Re: Trouble importing BookPrice

Hello, 

 

Thank you for your Reply. 

In fact, i checked the separator is comma and it's correct on the import source file.

Is there any other potential reason ? 

 

 Thanks in advance, 

 

 

ben_speight
Super Contributor

Re: Trouble importing BookPrice

The decimal separator is different from the column separator. If the values in the source file are of the form "0.84" then use dot, if they are of the form "0,84" use comma.

Sanaa
New Contributor

Re: Trouble importing BookPrice

Hello again, 

 

Thank you ^^ it worked 🙂

 

Have a good day.