dhis2-users team mailing list archive

[<duttas@xxxxxxxxxxxx>]

Hi Rin,

I am not sure if this will answer your question, but have you had a look at the indicator section of the manual? It has a good outline on how you can create your suggested formulas. You can also place these right into the dataset if you like so your user can see them calculated immediately.

From: Dhis2-users [mailto:dhis2-users-bounces+duttas=wpro.who.int@xxxxxxxxxxxxxxxxxxx] On Behalf Of riddy ndoma
Sent: 20 January 2014 06:49
To: Rin Channara
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] How to design in DHIS2

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<mailto: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<mailto: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)




====================================================
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.