Happy Business Starts Here

Highlighted
Zuora Support

Custom field value does not match in the Report vs UI

Question:

I have a user that has a custom field 'PromotionCode' on subscription rate plan but that doesn't match the report I am downloading, can you help me identify where the issue is?

189134 - raw 1.jpg189134 - raw 2.JPG

 

Answer:

This is a limitation from MS Excel and its not an issue from Zuora End.

Cause for this issue:

Excel follows the IEEE 754 specification on how to store and calculate floating-point numbers. Excel therefore stores only 15 significant digits in a number, and changes digits after the fifteenth place to zeroes.

Value for the "Promotion Code" field is "704578632193599621" which is 18 digit which is causing the error. When I entered 15 digits in my tenant for the field 
"704578632193599",  I can able to download the same value in the Excel reports.

Additional links for this issue in detail:
https://support.microsoft.com/en-in/help/269370/last-digits-are-changed-to-zeroes-when-you-type-long...
https://docs.microsoft.com/en-us/office/troubleshoot/excel/long-numbers-incorrectly-in-excel






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Tags (1)