dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Tom,

You can consult the DHIS2 mailing list archives for long and torturous
email threads on this issue and it has come up many times.

What would the desired behavior be in your case? Do you mean, that
something like

NA + 1 + 2 +3 = NA

This is not the default behavior at all in DHIS2, and most of the time
NAs/NULLS will be coerced to zero. So, the default behavior in DHIS2 is

NA + 1 + 2+ 3  = 6

In cases when the NAs are important, we have always had to resort to
SQL/R/Stata to perform the aggregation. But maybe there is a better
solution from someone else?

Best regards,
Jason




On Thu, May 31, 2012 at 8:13 AM, <hiattt@xxxxxxxxxxxx> wrote:

>  I see that when indicators are calculated, records where either the
> numerator or denominator is missing are not excluded. For me this would be
> ideal default behavior so that the indicator isn’t thrown wildly off by
> assuming no reporting is the same as reporting 0. I could imagine some
> times when one would want an unreported numerator to be treated as 0 (if
> it’s likely that it isn’t reported, because it doesn’t exist), so maybe an
> option to override default in the indicator definition screen would be
> good. I can’t think of a scenario where one would want missing denominators
> to be treated as 0.****
>
> ** **
>
> I don’t know if others are running into this, or if it’s only me. If there
> is a way to set this already let me know.****
>
> ** **
>
> Thanks,****
>
> Tom****
>
> ** **
>
>
>
>
>
>  ------------------------------
>
> This message was scanned for viruses with Trend Micro ScanMail, GFI
> MailSecurity and GFI MailEssentials by the World Health Organization
> Regional Office for the Western Pacific. However, the recipient is advised
> to scan this e-mail and any attached files for viruses.
>
> Disclaimer:
>
> This e-mail, together with any attachments, is intended for the named
> recipients only and is confidential. It may also be privileged or otherwise
> protected by law.
>
> If you have received it in error, please notify the sender immediately by
> reply e-mail and delete it and any attachments from your system. You may
> not copy or disclose its contents to anyone.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>