# Compound Data Element

Hi,

I would like to create a data element that is a calculation involving multiple data elements. For example, if I have data elements A, B, C and D, I would like data element D to be a calculation as follows: D = A + B - C.

How can I do this in DHIS?

Regards,

Edwin

In DHIS2 terminology, this is referred to as an indicator. You can find them documented in the documentation, such as here

http://www.dhis2.org/doc/snapshot/en/user/html/ch12.html#indicator

Regards,

Jason

···

On Wed, Dec 11, 2013 at 3:19 PM, Edwin Mulwa eddiemu@gmail.com wrote:

Hi,

I would like to create a data element that is a calculation involving multiple data elements. For example, if I have data elements A, B, C and D, I would like data element D to be a calculation as follows: D = A + B - C.

How can I do this in DHIS?

Regards,

Edwin

Jason,

We have tried using indicators but it has not worked for us. As we see it, in DHIS an Indicator must always have a denominator.

For us to fit in that rule and make our element D an indicator, we believe we have an option of dividing it with an element (let’s call it F) that must always be =1 so that it doesn’t change our value of D. So our indicator D=(A+B-C)/F. How to predefine the indicator F so that it is a constant 1 is a challenge. So it seems we cannot use the indicator method since most of our elements are not normally defined by a denominator but are rather additions and subtractions.

Thoughts?

Edwin

···

On Wed, Dec 11, 2013 at 4:44 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

In DHIS2 terminology, this is referred to as an indicator. You can find them documented in the documentation, such as here

http://www.dhis2.org/doc/snapshot/en/user/html/ch12.html#indicator

Regards,

Jason

On Wed, Dec 11, 2013 at 3:19 PM, Edwin Mulwa eddiemu@gmail.com wrote:

Hi,

I would like to create a data element that is a calculation involving multiple data elements. For example, if I have data elements A, B, C and D, I would like data element D to be a calculation as follows: D = A + B - C.

How can I do this in DHIS?

Regards,

Edwin

Hi Eddie,

You need to create a new indicator type, and be sure that “Number” is set to “True” and “Factor” is set to 1. This will have the affect of not requiring a denominator when you create indicators of this type.

If you have Constants as you mention which never change, you can create them in “Data administration”->Constants and then use them in your indicator formula.

Best regards,

Jason

–Sent from my mobile

···

On Sat, Dec 14, 2013 at 8:56 AM, Edwin Mulwa eddiemu@gmail.com wrote:

Jason,

We have tried using indicators but it has not worked for us. As we see it, in DHIS an Indicator must always have a denominator.

For us to fit in that rule and make our element D an indicator, we believe we have an option of dividing it with an element (let’s call it F) that must always be =1 so that it doesn’t change our value of D. So our indicator D=(A+B-C)/F. How to predefine the indicator F so that it is a constant 1 is a challenge. So it seems we cannot use the indicator method since most of our elements are not normally defined by a denominator but are rather additions and subtractions.

Thoughts?

Edwin

On Wed, Dec 11, 2013 at 4:44 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

In DHIS2 terminology, this is referred to as an indicator. You can find them documented in the documentation, such as here

http://www.dhis2.org/doc/snapshot/en/user/html/ch12.html#indicator

Regards,

Jason

On Wed, Dec 11, 2013 at 3:19 PM, Edwin Mulwa eddiemu@gmail.com wrote:

Hi,

I would like to create a data element that is a calculation involving multiple data elements. For example, if I have data elements A, B, C and D, I would like data element D to be a calculation as follows: D = A + B - C.

How can I do this in DHIS?

Regards,

Edwin

Ok, will give that a shot and see if it works.

Thanks!

···

On Sat, Dec 14, 2013 at 10:06 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Eddie,

You need to create a new indicator type, and be sure that “Number” is set to “True” and “Factor” is set to 1. This will have the affect of not requiring a denominator when you create indicators of this type.

If you have Constants as you mention which never change, you can create them in “Data administration”->Constants and then use them in your indicator formula.

Best regards,

Jason

–Sent from my mobile

On Sat, Dec 14, 2013 at 8:56 AM, Edwin Mulwa eddiemu@gmail.com wrote:

Jason,

We have tried using indicators but it has not worked for us. As we see it, in DHIS an Indicator must always have a denominator.

For us to fit in that rule and make our element D an indicator, we believe we have an option of dividing it with an element (let’s call it F) that must always be =1 so that it doesn’t change our value of D. So our indicator D=(A+B-C)/F. How to predefine the indicator F so that it is a constant 1 is a challenge. So it seems we cannot use the indicator method since most of our elements are not normally defined by a denominator but are rather additions and subtractions.

Thoughts?

Edwin

On Wed, Dec 11, 2013 at 4:44 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

In DHIS2 terminology, this is referred to as an indicator. You can find them documented in the documentation, such as here

http://www.dhis2.org/doc/snapshot/en/user/html/ch12.html#indicator

Regards,

Jason

On Wed, Dec 11, 2013 at 3:19 PM, Edwin Mulwa eddiemu@gmail.com wrote:

Hi,

I would like to create a data element that is a calculation involving multiple data elements. For example, if I have data elements A, B, C and D, I would like data element D to be a calculation as follows: D = A + B - C.

How can I do this in DHIS?

Regards,

Edwin