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
