Archives
DeltaMaster clicks!
June 2010
Trick of the month:
Null values, 0 and null members -
much ado about nothing
in analytical applications
June 2010
Greetings, fellow data analysts!
When the ancient Babylonians invented the number 0, they turned 'nothing' into something tangible. Giving 'nothing' a name and face was a fundamental requirement for progress. After all, our numerical, decimal, and almost all denominational number systems wouldn't work without a 0. The alternative would be to do math using tally sheets or Roman numerals - which is really difficult to say the least.
A common cliché says that the only thing that computer science needs besides a 0 is a 1. And although a '1' is always unique, 'nothing' is not always the same, too: A missing value is completely different than a value that shows when the cash is indeed empty. You can really philosophize over these and other variations of 'nothing'. But we will save that for another time and place. What interests us in this edition of clicks! is how null values, the number '0', and null members influence reports and analyses.
You'll see that DeltaMaster not only makes it easier to work with numbers. It is also a great help when they are missing.
Best regards,
Your Bissantz & Company team
Download the full June 2010 DeltaMaster clicks! in PDF format
Archives
Missed a number?
Here are the past 79 issues.
- 2012:
- 2011:
- 2010:
- 2009:
Current issue
DeltaMaster clicks! 01/2012:
Copying reports with
modified views
Download
The June 2010
DeltaMaster clicks! as PDF
Subscribe
Get your clicks! delivered every month
About DeltaMaster
More about our software suite for Analysis, Planning, and Reporting