import file amount rounding

hi anaplaner,

i have problem about impor/upload file, when iam upload file number format, data in anaplan and excel file always different, ex: excel file 497.157.884.509 but in anaplan 497.157.000.000.

how to fixing that problem?, and why is that?

Thanks,

Panji

Accepted answers

JaredDolich

@Panji

Anaplan is very particular about the Excel formatting, especially with decimal places.

In your case, I'm guessing your Excel value is displaying in scientific notation. You will need to change that to normal notation.

Example,

In Excel I have two formats. Both have the same number but one is in Scientific Notation.

I import both of these values into Anaplan. See what happens?

The scientific notation is taken literally.

If you change you Excel format to show all the digits, you should be okay.

LipChean_Soh

Hi @Panji

If your number uses 'dot' as thousand separator, you can do the following:

1. Assuming this is the data file, note that the thousand separator is 'dot'

Screen Shot 2019-12-20 at 10.07.33.png

2. Blueprint format of receiving Anaplan module. Note the change to 'Thousand Separator'

Screen Shot 2019-12-20 at 10.07.45.png

3. In your import action definition, change the 'Decimal Separator' to 'Comma'.

Screen Shot 2019-12-20 at 10.08.10.png

4. Below is the end result in the receiving module.

Screen Shot 2019-12-20 at 10.07.38.png

Thanks,

LipChean

All comments

JaredDolich

@Panji

Anaplan is very particular about the Excel formatting, especially with decimal places.

In your case, I'm guessing your Excel value is displaying in scientific notation. You will need to change that to normal notation.

Example,

In Excel I have two formats. Both have the same number but one is in Scientific Notation.

I import both of these values into Anaplan. See what happens?

The scientific notation is taken literally.

If you change you Excel format to show all the digits, you should be okay.

LipChean_Soh

Hi @Panji

If your number uses 'dot' as thousand separator, you can do the following:

1. Assuming this is the data file, note that the thousand separator is 'dot'

Screen Shot 2019-12-20 at 10.07.33.png

2. Blueprint format of receiving Anaplan module. Note the change to 'Thousand Separator'

Screen Shot 2019-12-20 at 10.07.45.png

3. In your import action definition, change the 'Decimal Separator' to 'Comma'.

Screen Shot 2019-12-20 at 10.08.10.png

4. Below is the end result in the receiving module.

Screen Shot 2019-12-20 at 10.07.38.png

Thanks,

LipChean

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
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…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…