Timeline for How can I explain the difference between NULL and zero?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 14, 2012 at 13:54 | history | edited | gnat | CC BY-SA 3.0 | spelling cleanup |
| Feb 13, 2012 at 22:01 | history | made wiki | Post Made Community Wiki by Vasiliy Sharapov | ||
| Feb 13, 2012 at 19:57 | comment | added | HLGEM | IN a percent change zero means specifically there was no change (old and new values were exactly the same), null means there was a change but the percentage cannot be determined. This is why you probably do not want to show zero as teh result as it is misleading. | |
| Feb 13, 2012 at 19:54 | comment | added | O.O | From a users point of view 0 and NULL in the case of old value would not equate a difference (e.g. if I have to show a value in a textbox). In percent change, having no value could mean the same as null or zero, right? | |
| Feb 13, 2012 at 19:50 | history | answered | HLGEM | CC BY-SA 3.0 |