Number values getting inflated by 10x when importing from file

JMiddleton

Hi all,

 

I'm having an issue when loading a data file to a client's Data Hub. The target module has several line items, some of which are number formatted. When I load the source file one of the numerical columns is getting inflated by 10x once it's populated in the target module.

 

For example, there's a value of 468,408.66 (formatted as 468408.66) in the source file. However, once the same value is populated in Anaplan via the import action created for it, the value is inflated to 46,840,866.00. It seems as though Anaplan is misinterpreting the location of the decimal point.

 

I've tried adjusting the number format configuration many different ways, adjusting the language in my browser settings, and changing the number format in the source file, all to no avail. This also happens when someone on the client side tries loading the same file.

 

Has anyone ever run into this type of behavior in Anaplan before?

jasonblinn

@JMiddleton 

 

In the Import Source, can you confirm that the decimal separator is correct? 

Secondly, can you confirm that your source file does not have that intersection 10 times in it? If it has all of the same dimensions, and it has 10 instances that would hit the same cell, it will add them together as part of the load. 

 

For example: Here I am importing into an Employee list, dimensionalized by Time. This is my file:

 

Since there are multiple instances of Employee 1 and Jan 18, it is adding them together once I load the file.

 

 

Jason