dhis2-users team mailing list archive

[riddy ndoma <riddyndoma@xxxxxxxxx>]

Hi Rin,

You can customize your Dataset. By putting in cells that are to receive the
respective formulas total.

By the way, I wanted to know what you call S1?


2014/1/20 Rin Channara <RChannara@xxxxxxxxxx>

>  Dear all dhis2 user,
>
> I have one problem. If the data in store like below. So how DHIS2 can
> solve this problem?
>
> The user fill only Q1 and Q2 for “old” and “new” with category option of
> “Female” and “Male”
>
> So how to design and use functions to auto calculate S1 with the following
> formula?
>
> Q1:
>
> *Code*
>
> *Indicators*
>
> *Quarter 1*
>
> *Old*
>
> *New*
>
> *Total*
>
> *F*
>
> *M*
>
> *Total*
>
> *F*
>
> *M*
>
> *Total*
>
> *F*
>
> *M*
>
> *Total*
>
> KC0104
>
> Number of PWID reached by needles/syringe program including minimum
> HIV/Drug prevention activities
>
> 4
>
> 3
>
> *7*
>
> 1
>
> 2
>
> *3*
>
> 5
>
> 5
>
> *10*
>
>
>
> Q2:
>
> *Code*
>
> *Indicators*
>
> *Plan for Quarter 2*
>
> *Old*
>
> *New*
>
> *Total*
>
> *F*
>
> *M*
>
> *Total*
>
> *F*
>
> *M*
>
> *Total*
>
> *F*
>
> *M*
>
> *Total*
>
> KC0104
>
> Number of PWID reached by needles/syringe program including minimum
> HIV/Drug prevention activities
>
> 1
>
> 2
>
> *3*
>
> 3
>
> 4
>
> *7*
>
> 4
>
> 6
>
> *10*
>
>
>
>
>
> Semester:1
>
> *Formula: *
>
> *1.*      *"Old" in Semester 1 is get from "Old" in Q1*
>
> *2.*      *"New" in Semester 1 is get from "New" in Q1 + "New" in Q2*
>
>
>
> *Code*
>
> *Indicators*
>
> *Semester 1*
>
> *Old*
>
> *New*
>
> *Total*
>
> *F*
>
> *M*
>
> *Total*
>
> *F*
>
> *M*
>
> *Total*
>
> *F*
>
> *M*
>
> *Total*
>
> KC0104
>
> Number of PWID reached by needles/syringe program including minimum
> HIV/Drug prevention activities
>
> 4
>
> 3
>
> *7*
>
> 4
>
> 6
>
> *10*
>
> 8
>
> 9
>
> *17*
>
>
>
>
>
> Thank you very much
>
> RIN CHANNARA
>
> _______________________________________________
> 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
>
>


-- 
Riddy NDOMA
Software Developer
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)