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.
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.
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.
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.
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.
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.
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.
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.