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
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@fhi360.org
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@lists.launchpad.net
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)
Duttas
20 January 2014 22:08
3
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.
···
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@fhi360.org
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@lists.launchpad.net
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)