why I importad data from csv show 100x bigger than the original file?

Lazlo
Lazlo
in Academy Discussions

hello

I tried to finish the L1 training and in the 8.5.2 steps when I import the price book data in the anaplan model I saw values that 100x bigger than the original values in the csv file. like example csv file show: 0,84 in my model I see 84.0. not sure what cause this problem. is it coming from my local xls settings? if yes what should I check? also when I imported everything to anaplan, I receive 0 error, so from the system side I think everything went well.

thank you for the ideas.

Best Answer

  • Lazlo
    Lazlo
    Answer ✓

    Hello, thanks for the comment. I checkted the training materials and in rev01 price book i should have a format of usd currency 2 decimals. if i change it to percentage the whole model is will be wrong, since i import the unit price and that should be a number.

    i found out in the import steps i need fo modify the the thousand separator from come to dot. now it looks ok. i managed to import the correct values

    thank you

Answers

  • Dikshant
    Dikshant

    The line item format should be percentage. That's why values that you have in excel is showing 100x more in Anaplan. If you have 1 in excel, Anaplan shows 100%.

Categories