Problem
Sometimes when trying to integrate large number of fields into Totango it is possible that these values come in scientific notation. When this happens they need to be converted from Scientific notation to a number value so that they show up in Totango correctly and any calculations are done correctly as well. To do this we need to create a formula using the Customer Data Hub Field Functions.
Solution
To load these values in scientific notation into Totango you have to leave them as a text-type field and use the function editor to create a formula to convert them into the correct format.

- VALUE(<Field In Scientific Notation>)
- VALUE(TEXT(VALUE(<Field In Scientific Notation>), "$0.00"))



More on Customer Data Hub Function Editor
- Customer Data Hub Field Functions
- Totango Field Functions Formulas
- Customer Data Hub Source Field Formatting
For Further Assistance
If this article does not resolve the issue, please contact Totango Support for further assistance.