Efficient way of exporting large number values from Anaplan

Options
frankestein178
frankestein178 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 New Contributor
in Extensibility

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.

 

 

 

Tagged:

Comments

  • frankestein178
    frankestein178 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 New Contributor

    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

  • frankestein178
    frankestein178 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 New Contributor

    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
    frankestein178 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 New Contributor

    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

Categories