Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Hide #DIV/0!% for Calculated Metrics

Avatar

Level 2

8/12/10

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