← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 436692] Re: Blanks are displayed as 0 in report

 

2009/9/26 Jason Pickering <jason.p.pickering@xxxxxxxxx>

> 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

Follow ups

References