Trouble importing BookPrice

Sanaa
Sanaa
in Modeling

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, 

Tagged:

Answers

  • ben_speight
    ben_speight

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

  • Sanaa
    Sanaa

    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
    ben_speight

    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
    Sanaa

    Hello again, 

     

    Thank you ^^ it worked 🙂

     

    Have a good day. 

Categories