Calculation with strings

[fernandoshake]

Hi everyone,

In my program stage, I Have a list of yes/no questions. The answers are selected from a dropdown list (option set). I want to calculate total score based on the total of yes responses (numerator)/total of responses (denominator)x100. I would like to display the following classification in the tracker dashboard:

If Total score is >= 80%: C

If Total score is >= 50%: CNI

If Total score is < 50%: NC

Can you anyone in the community provide me with a step-by-step explanation about how to get this done.

Looking forward to an answer

Thanks

[jaime.bosque (Jaime)]

This post explains something very similar and probably you can use as a baseline for what you are trying to achieve.

Program rule, assign value by summing boolean data elements

Hi @Natalie_Tibbels. I have created a quick demo on the https://play.dhis2.org/2.34.0/ but I guess it will be deleted tonight; so I am adding a metadata package (remove the .pdf extension as it is a .zip)metadata.json.zip.pdf (3.3 KB) that you could import in the play server. To be honest I was a bit more difficult that I initially thought because of the differences between the PR in Android and web. The result in web|android is (what I think you wanted); note that I have added a “3” by defa…

Cheers!

[fernandoshake]

Hi @jaime.bosque,

Would it possible to achieve what I want by using program indicators so that the classification is displayed in the tracker dashboard?

Thanks

[asacur (Abdul Sacur)]

Hi @fernandoshake yes it is possible. As you will assign this to a data element. From there you can create a regular indicator if you want.
Thanks