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, <[email protected]> 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, <[email protected]> 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 : [email protected] >>> 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: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
