Efficient way of exporting large number values from Anaplan

Highlighted
New Contributor

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.

 

 

 

7 REPLIES 7
Highlighted
Master Anaplanner/Community Boss

Re: Efficient way of exporting large number values from Anaplan

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!

Regards,
Kavin.
Highlighted
Community Boss

Re: Efficient way of exporting large number values from Anaplan

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.

Highlighted
New Contributor

Re: Efficient way of exporting large number values from Anaplan

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

Highlighted
New Contributor

Re: Efficient way of exporting large number values from Anaplan

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

Highlighted
Certified Master Anaplanner

Re: Efficient way of exporting large number values from Anaplan

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").Test.png

Magali Pelissier, Product Manager - Extensions (Excel Add-in, PowerPoint Add-in, Google Sheets Add-on)
Check out our dedicated Community page in the Platform section!
Highlighted
New Contributor

Re: Efficient way of exporting large number values from Anaplan

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

Highlighted
Certified Master Anaplanner

Re: Efficient way of exporting large number values from Anaplan

 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

Magali Pelissier, Product Manager - Extensions (Excel Add-in, PowerPoint Add-in, Google Sheets Add-on)
Check out our dedicated Community page in the Platform section!