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?

Accepted answers

DavidSmith

@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

All comments

DavidSmith

@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

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

@egc8r

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

egc8r

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.

Quick Links

Can you help?

Unanswered questions

別ディメンションで、セレクターをモジュールに返し、計算したい
下記のようなことがしたいですコンテキストセレクターの値を別モジュールに反映し、それを使って計算したいです。 selecter A-1 Dim code amount Select→ A-1 1 100 A-2 2 100 A-3 3 100 A-4 4 100 module Dim code amount key Flg A-1 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 2 2 50 A-2 FALSE 2 2 50 A-2 FALSE
Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…