Hide #DIV/0!% for Calculated Metrics | Community
Skip to main content
briankbc
Level 2
August 12, 2010
New

Hide #DIV/0!% for Calculated Metrics

  • August 12, 2010
  • 0 replies
  • 780 views

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