Decimal points dropping off amounts when uploading data file

Loraine
Occasional Contributor

Decimal points dropping off amounts when uploading data file

I am uploading a .csv file with amounts that have dollars and cents.  Whether the columns in my module are set to use decimal places or not, it is not recognizing the cents.  1633.34 shows up like 163334 when no decimal places are formatted and 163334.00 when I use 2 decimal places.  Is there a way to see the amounts in the module with the decimal place correctly showing?

4 REPLIES 4
DavidSmith
Master Anaplanner/Community Boss

Re: Decimal points dropping off amounts when uploading data file

@Loraine 

A couple of things to watch

 

1. If you are saving from excel, ensure that the format is specifically forcing it to 2dp.  I recommend not using any delimiter for thousands.  I've seen it where the CSV doesn't save the decimals

2. Check the import settings for decimal delimiter in the initial mapping screen.  If they are not coming through it might be set to something other than "."

 

I hope that helps

David

 

 

egc8r
Occasional Contributor

Re: Decimal points dropping off amounts when uploading data file

Hi,

I have confirmed that the csv has the decimal information and that the decimal delimiter is a dot, and I am still losing the decimals.  Any other ideas?

 

Thanks,

Ethan

rob_marshall
Moderator

Re: Decimal points dropping off amounts when uploading data file

@egc8r 

 

And can you confirm the decimal places for that line item is not set to 0?

 

2021-01-14_16-02-33.png

egc8r
Occasional Contributor

Re: Decimal points dropping off amounts when uploading data file

Hi, I have since changed the decimal places to 2, and things are working now.  I find it curious that a display setting affects the function of a load.  In any case, I consider my problem resolved.

 

Thanks.