Efficient way of exporting large number values from Anaplan

I have a line item which contains number values, usually 13 to 15 digits long.

While exporting these number values data is converted into scientific format.

For example in Anaplan grid, we can see number as 1,522,731,938,281.0 . Whereas, in the export the same number gets converted into 1.522731938281E12.(Scientific format)

In exports, I don't want numbers to be in scientific format. I want them as it's showing in Anaplan.

Let me know how to handle this issue. Screenshot attached for reference.

Excel_Export_66779.JPG

Number_In_Anaplan_66779.png

Accepted answers

MagaliP

Hi,

I have just tested it with the Excel add-in and it gives the expected result (see screenshot).

You can find the documentation (including the add-in to download) and best practices (in particular performance information as you mention an "efficient way").

All comments

kavinkumar

HI @frankestein178,

Can you try this?

Convert the number to text in Anaplan and try exporting that to .TXT file. This should solve your problem.

Hope it helps!

ben_speight

Text exports represent numbers greater than 10^14 (or less than -10^14) in scientific format.

I believe the TEXT calculation function will not use scientific notation if the number has no fraction and has absolute magnitude below 9,007,199,254,740,992. So this solution will work for this example, but has its limits.

frankestein178

Hi @kavinkumar ,

Thank you for your response.

Yes, you are correct. But requirement is to take the export in .csv and .xlsx format.

Hence, any solution while taking export in csv & excel file format?

Thanks,

Himanshu

MagaliP

Hi,

I have just tested it with the Excel add-in and it gives the expected result (see screenshot).

You can find the documentation (including the add-in to download) and best practices (in particular performance information as you mention an "efficient way").

frankestein178

Hi @ben_speight , @kavinkumar

Thank you for your response.

We have data in both fractional and non fractional format. What will be the best approach to handle this issue?

Thanks,

Himanshu

frankestein178

Hi @MagaliP ,

Thank you for suggesting the excel add-ins.

However, could you please suggest how to fix the issue in Anaplan as the data is being sent from Anaplan?

Thanks,

Himanshu

MagaliP

Hi Himanshu,

Thank you for your reply. I am afraid I do not know how to do this if the previously mentioned methods of exporting data do not work

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…