Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Hide #DIV/0!% for Calculated Metrics

Avatar

Avatar
Boost 5
Level 2
briankbc
Level 2

Likes

22 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 2
briankbc
Level 2

Likes

22 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
View profile
briankbc
Level 2

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