Number values getting inflated by 10x when importing from file
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?