dhis2-users team mailing list archive

[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