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

Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Blog: http://riddyndoma.blogspot.com/

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

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