Hi Rabbia, What is not working? Could you be more specific? Data elements of type "True only" should aggregate to 1 when marked as true.
Regards, Jason On Tue, Oct 31, 2017 at 2:05 PM, <rab...@pace-tech.com> wrote: > On 2017-10-30 19:28, Jason Pickering wrote: > >> Hi Rabbia, >> Just use the True Only type of data element. It should work. >> >> Regards, >> Jason >> >> Hi Jason, > its not working and if we want the same thing to be done on number data > type or you can say integer. what i need to do then ? > > Regards: Rabbia Naz > > On Oct 30, 2017 08:09, <rab...@pace-tech.com> wrote: >> >> Aoa, >>> >>> I need to ask a question about indicators like i want to sum the >>> value of numerator on the basis of data element like "sum(case when >>> devalue=true then 1 else 0 end) as totaltrue". like how can we >>> calculate the conditional sum for data element whose type is >>> aggregated not tracker. Kindly explain in detail. >>> Thank You >>> Regards: Rabbia Naz >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users [1] >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users [1] >>> More help : https://help.launchpad.net/ListHelp [2] >>> >> >> >> Links: >> ------ >> [1] https://launchpad.net/~dhis2-users >> [2] https://help.launchpad.net/ListHelp >> > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp