2009/9/26 Jason Pickering <[email protected]> > Hmm, now I am even more confused than normal. We just established that > "missing" values in the map, get displayed as 0. If I look in my > aggregateddatavalue table, there are values that are exactly displayed > as 0. There are other values that get displayed as 0.0 (which appears > to be the result of a float operation). If I go back into my dataset, > the values that are 0.0 are actual zeros, whereas the 0 (no decimal > places) appear to be the result of NULLS (in a recordset) being > coerced to zeroes. > > Now it would seem this is not actually the case, as you say that the > datamart does not export empty values? > > I really need to understand and deal with this, as missing data values > is a fact of life in our data here in Zambia. > > OK then I must rephrase to "should not" write 0 values to theaggregateddatavalue table:-) Not able to reproduce it here but if you and Ola are getting 0s after running a datamart a will start looking for a bug.
Lars
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
