Expand my Community achievements bar.

Join us January 15th for an AMA with Champion Achaia Walton, who will be talking about her article on Event-Based Reporting and Measuring Content Groups!

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