Hide #DIV/0!% for Calculated Metrics

Avatar

Avatar

briankbc

Avatar

briankbc

briankbc

12-08-2010

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

Comment