You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to load more than 2 decimal places

Hello,

  1. We are loading exchange rates to planning from a file through data management and the values in rates column have 14 decimal places(Ex values: .73172146606776, 1.29416076088267) and we need to have all those 14 decimal places but only 2 decimal places are getting loaded.
  2. Can we load data from .xlsx file through data management with tab delimiter because we are getting source file in .xlsx format? (OR) To use tab delimiter, do I need to save the .xlsx file as .txt? When I am using .xlsx file with tab delimiter, import step is getting failed and when I use .txt file with tab delimiter, it is successfully importing.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!