Percentage data to high when importing from csv file

Is seem to have problem with importing data for list items with type percentage.

For example, in the Model builder 1 course i try to import data to list item Bonus % in the EMP01 Employee Drivers module. The format looks as follow:

The data in the csv file is for example 0,12. So this should translate into 12% once imported, but the result that I receive is this:

So it seems like it's 100 times higher than it should. What do I do wrong here?

Accepted answers

All comments

bhatjaved

In this case you can fix the source and convert % column to decimals which will give you correct % in line items or you may create additional line item in module to further divide the source and have percentage line item populated

ChrisAHeathcote

@hannaaberg

Check the settings in the import to ensure that you are recognising the decimal and thousand separators correctly.

I suspect the current settings are recognising dot as the thousand separator and comma as the decimal separator.

Be mindful of the formatting of the source data when importing.

hannaaberg

In which step in the import do I check this? I can only se that this looks OK but there is no way of finding out how Anaplan interprets the actual bonus % data?

The decimal point is set to "." and the thousand seperator is set to "," so I don't think that your initial hypothesis holds since the csv has a "."

ChrisAHeathcote

@hannaaberg

You need to create a new data source by selecting the data source again and reconfiguring the settings.

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…