Double Metadata being Truncated in reports and excel outputs

Question

I am pulling together financial data and some of the values are in the 100s of billions of digits and within AYX the values are not being rounded or truncated but once i export to excel it rounds the value.

Currently the metadata is set to Double and the value is -114,695,054,238 and once output to excel it converts to -114,695,000,000. How can i prevent this from happening?

When this same value is output via reporting and render tool it only outputs only -114,695,054. What preferences in table or layout or render do I need to select?

Samantha_Jayne · Answer

Interesting point to note, I will raise internally and see what I can find. If this did help, please can you mark it as a solution for others to also find the answer helpful in future.

Many thanks,

GSxMuscleMlk · Answer

Thanks for sending over your workflow. I noticed you were using .xls vs my flow which was using .xlsx.

Once i updated my flow to use the .xls it worked as desired.

i'm using an outdated version due to company restriction, 2020.2.3.27789 - Could this be the true reason?

Samantha_Jayne · Answer

Hi @GSxMuscleMlk

what version are you using of Designer?

I just tried this in mine and I was able to get the desired result.

Not sure what is happening on your side, so I have attached my workflow example, in case it helps.

Exporting Large Numbers to Excel.yxmd