Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.

Hide #DIV/0!% for Calculated Metrics


Level 2


When calculated metrics contain division by a metric that may be 0, #DIV/0!% appears in the reports.


This should show simply as - or N/A rather than implying that there is an error in the calculations.


That's fine for Excel, where one has more powerful logic to deal with it.


But is that ok in an expensive, enterprise-level presentation tool?

And in a field where confidence in our metrics must be earned repeatedly?


Brian Katz