Analytics Report Builder reports are sending scientific notation in PDF

This article addresses the issue where an Adobe Analytics report shows numbers in scientific notation when generating a PDF. The workaround is to use the Text() function in the scheduled ARB (Analytics Report Builder) report to convert the numerical values into their text representations. This resolves any discrepancies between Excel settings on your computer and the Report Builder scheduling server, allowing for accurate reporting.

Description description

Environment

Adobe Analytics

Issue

An ARB scheduled report is showing numbers in scientific notation in a PDF.

Cause

This is caused by a difference in settings between Excel on your computer and on the Report Builder scheduling server.

Resolution resolution

Use the Text() function in the scheduled ARB report to turn the value into its textual representation.