Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in Program indicator expressions

[Sam Johnson]

Hi Markus and Bernard,

At the start of last year, we reported this exclusion of parentheses from all 
program indicator functions as a bug 
(DHIS2-590<https://jira.dhis2.org/browse/DHIS2-590>), but it actually turned 
out to be intentional, so was changed from a bug to an Improvement.

Since it seems to keep cropping up as an issue, is there any chance we could 
sneak this Improvement into 2.30?  Even if, for performance reasons, we still 
need to exclude nested functions, it would be great to be able to use 
parentheses within function expressions.

Cheers, Sam.


From: Dhis2-users 
<dhis2-users-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf 
of Markus Bekken <mar...@dhis2.org>
Date: Friday, 9 February 2018 at 09:20
To: "Bernard Sadaka (IM Advisor)" <lib@pu-ami.org>
Cc: dhis2-users <dhis2-us...@lists.launchpad.net>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-users] [Dhis2-devs] Using program rule expressions in 
Program indicator expressions

Hi again Bernard,
it seems that the problem you experience might be caused by the presence of 
parenthesis in the expression inside your d2:condition. This is a bug, and can 
be followed up here: https://jira.dhis2.org/browse/DHIS2-2813
If you are able to write your expression without parenthesis, this is a 
workaround that you can use.

The general implementation of new functions in program indicators is followed 
up in jira issues, but there was none covering the mathematical functions you 
need here, so I created one that you can look at: 
https://jira.dhis2.org/browse/DHIS2-2814
Please complement or comment, and consider voting for it :)

Best regards,
Markus

P.S. won't X*100%100 always be 0?


7. feb. 2018 kl. 09:21 skrev Bernard Sadaka (IM Advisor) 
<lib@pu-ami.org<mailto:lib@pu-ami.org>>:

Hello Markus,
Thank you for the list and explanation; is there any expected timeline for 
that? (JIRA issue, I can track?)

With regards to the number of decimals, even if set to zero at the program 
indicator and after running the analytics, the “pivot table” still shows the 
digits.

Regarding the expression, yes it is true, I’m rounding the constants, because I 
am actually creating a budget report and applying a discount rate on the 
individual cost of a specific PHCC activity and aggregating them using sum (so 
I am using one constant per cost of a PHCC activity and another for discount 
rate of all activities). I ended up using exact values in the constant instead 
of a discounted factor; after all, changing a discount factor is easier than 
changing 200 values individually when the discount rate changes. The reason for 
all this, is that with a discounted factor there is a need to round the values 
and disallow them to be cumulated in the sum of the aggregation in order to 
keep the report error free.
Hope the above explains my usecase: aggregating the data elements of a TEI and 
multiplying them by a cost constant and a discount factor. And yes the round 
functions in this case would be very beneficial.

Thank you again for your support.

All the best,
Bernard



Bernard Sadaka
Information Management Advisor
Première Urgence - Aide Médicale Internationale
Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
Ain el Remmaneh, Beirut, Lebanon
E-mail: lib@pu-ami.org<mailto:lib@pu-ami.org>
Cell: +961 71 004 881 (208)
Skype: imapuami
Website: https://www.pu-ami.org<https://www.pu-ami.org/>



From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Wednesday, February 7, 2018 9:52 AM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org<mailto:lib@pu-ami.org>>
Cc: dhis2-us...@lists.launchpad.net<mailto:dhis2-us...@lists.launchpad.net>; 
DHIS 2 developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in 
Program indicator expressions

Hi there Bernard,
We aim to support more and hopefully all the program rule functions in program 
indicators.
Unfortunately we are not there yet, and the list of supported functions in 
program indicators can be found here:
19.4.5. Reference information: Functions, variables and operators to use in 
program indicator expressions and 
filters<https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#program_indicator_functions_variables_operators>

Where did you get the wrong number of decimals? In the Pivot or in the 
Tracker/Event capture?

One question on your expression below, it seems you are trying to round off a 
constant from your defined constant values? Your use case I would have guessed 
is to round off a data element or tracked entity attribute value?

Best regards
Markus



6. feb. 2018 kl. 15:31 skrev Bernard Sadaka (IM Advisor) 
<lib@pu-ami.org<mailto:lib@pu-ami.org>>:

I found a similar issue on JIRA (https://jira.dhis2.org/brow

Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in Program indicator expressions

[Bernard Sadaka (IM Advisor)]

Thank You Markus,

I started following the 2 issues and voted for them.

As for (X*100)%100 , it returns the first 2 digits after the comma, therefore 
the expression mentioned earlier would have simulates a rounding function if 
the parenthesis were processed correctly as mentioned in the JIRA issue ;)

Thank you again for the support.

All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Friday, February 9, 2018 11:16 AM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>
Cc: dhis2-users <dhis2-us...@lists.launchpad.net>; DHIS 2 developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in 
Program indicator expressions



Hi again Bernard,

it seems that the problem you experience might be caused by the presence of 
parenthesis in the expression inside your d2:condition. This is a bug, and can 
be followed up here: https://jira.dhis2.org/browse/DHIS2-2813

If you are able to write your expression without parenthesis, this is a 
workaround that you can use.



The general implementation of new functions in program indicators is followed 
up in jira issues, but there was none covering the mathematical functions you 
need here, so I created one that you can look at: 
https://jira.dhis2.org/browse/DHIS2-2814

Please complement or comment, and consider voting for it :)



Best regards,

Markus



P.S. won't X*100%100 always be 0?





7. feb. 2018 kl. 09:21 skrev Bernard Sadaka (IM Advisor) <lib@pu-ami.org 
<mailto:lib@pu-ami.org> >:



Hello Markus,

Thank you for the list and explanation; is there any expected timeline for 
that? (JIRA issue, I can track?)



With regards to the number of decimals, even if set to zero at the program 
indicator and after running the analytics, the “pivot table” still shows the 
digits.



Regarding the expression, yes it is true, I’m rounding the constants, because I 
am actually creating a budget report and applying a discount rate on the 
individual cost of a specific PHCC activity and aggregating them using sum (so 
I am using one constant per cost of a PHCC activity and another for discount 
rate of all activities). I ended up using exact values in the constant instead 
of a discounted factor; after all, changing a discount factor is easier than 
changing 200 values individually when the discount rate changes. The reason for 
all this, is that with a discounted factor there is a need to round the values 
and disallow them to be cumulated in the sum of the aggregation in order to 
keep the report error free.

Hope the above explains my usecase: aggregating the data elements of a TEI and 
multiplying them by a cost constant and a discount factor. And yes the round 
functions in this case would be very beneficial.



Thank you again for your support.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Wednesday, February 7, 2018 9:52 AM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org <mailto:lib@pu-ami.org> 
>
Cc: dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net> ; 
DHIS 2 developers <dhis2-devs@lists.launchpad.net 
<mailto:dhis2-devs@lists.launchpad.net> >
Subject: Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in 
Program indicator expressions



Hi there Bernard,

We aim to support more and hopefully all the program rule functions in program 
indicators.

Unfortunately we are not there yet, and the list of supported functions in 
program indicators can be found here:

 
<https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#program_indicator_functions_variables_operators>
 19.4.5. Reference information: Functions, variables and operators to use in 
program indicator expressions and filters



Where did you get the wrong number of decimals? In the Pivot or in the 
Tracker/Event capture?



One question on your expression below, it seems you are trying to round off a 
constant from your defined constant values? Your use case I would have guessed 
is to round off a data element or tracked entity attribute value?



Best regards

Markus






6. feb. 2018 kl. 15:31 skrev Bernard Sadaka (IM Advisor) < 

Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in Program indicator expressions

[Markus Bekken]

Hi again Bernard,
it seems that the problem you experience might be caused by the presence of 
parenthesis in the expression inside your d2:condition. This is a bug, and can 
be followed up here: https://jira.dhis2.org/browse/DHIS2-2813 
<https://jira.dhis2.org/browse/DHIS2-2813>
If you are able to write your expression without parenthesis, this is a 
workaround that you can use.

The general implementation of new functions in program indicators is followed 
up in jira issues, but there was none covering the mathematical functions you 
need here, so I created one that you can look at: 
https://jira.dhis2.org/browse/DHIS2-2814 
<https://jira.dhis2.org/browse/DHIS2-2814>
Please complement or comment, and consider voting for it :)

Best regards,
Markus

P.S. won't X*100%100 always be 0? 

> 7. feb. 2018 kl. 09:21 skrev Bernard Sadaka (IM Advisor) <lib@pu-ami.org>:
> 
> Hello Markus,
> Thank you for the list and explanation; is there any expected timeline for 
> that? (JIRA issue, I can track?)
>  
> With regards to the number of decimals, even if set to zero at the program 
> indicator and after running the analytics, the “pivot table” still shows the 
> digits.
>  
> Regarding the expression, yes it is true, I’m rounding the constants, because 
> I am actually creating a budget report and applying a discount rate on the 
> individual cost of a specific PHCC activity and aggregating them using sum 
> (so I am using one constant per cost of a PHCC activity and another for 
> discount rate of all activities). I ended up using exact values in the 
> constant instead of a discounted factor; after all, changing a discount 
> factor is easier than changing 200 values individually when the discount rate 
> changes. The reason for all this, is that with a discounted factor there is a 
> need to round the values and disallow them to be cumulated in the sum of the 
> aggregation in order to keep the report error free.
> Hope the above explains my usecase: aggregating the data elements of a TEI 
> and multiplying them by a cost constant and a discount factor. And yes the 
> round functions in this case would be very beneficial.
>  
> Thank you again for your support.
>  
> All the best,
> Bernard
>  
> 
> Bernard Sadaka
> Information Management Advisor
> Première Urgence - Aide Médicale Internationale
> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
> Ain el Remmaneh, Beirut, Lebanon
> E-mail: lib@pu-ami.org <mailto:lib@pu-ami.org>
> Cell: +961 71 004 881 (208)
> Skype: imapuami
> Website: https://www.pu-ami.org <https://www.pu-ami.org/>
>  
>  
> From: Markus Bekken [mailto:mar...@dhis2.org] 
> Sent: Wednesday, February 7, 2018 9:52 AM
> To: Bernard Sadaka (IM Advisor) <lib....@pu-ami.org>
> Cc: dhis2-us...@lists.launchpad.net; DHIS 2 developers 
> <dhis2-devs@lists.launchpad.net>
> Subject: Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in 
> Program indicator expressions
>  
> Hi there Bernard,
> We aim to support more and hopefully all the program rule functions in 
> program indicators.
> Unfortunately we are not there yet, and the list of supported functions in 
> program indicators can be found here:
> 19.4.5. Reference information: Functions, variables and operators to use in 
> program indicator expressions and filters 
> <https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#program_indicator_functions_variables_operators>
>  
> Where did you get the wrong number of decimals? In the Pivot or in the 
> Tracker/Event capture?
>  
> One question on your expression below, it seems you are trying to round off a 
> constant from your defined constant values? Your use case I would have 
> guessed is to round off a data element or tracked entity attribute value?
>  
> Best regards
> Markus
> 
> 
>> 6. feb. 2018 kl. 15:31 skrev Bernard Sadaka (IM Advisor) <lib@pu-ami.org 
>> <mailto:lib@pu-ami.org>>:
>>  
>> I found a similar issue on JIRA (https://jira.dhis2.org/browse/DHIS2-2734 
>> <https://jira.dhis2.org/browse/DHIS2-2734>)
>>  
>> But still doesn’t explain why I can’t use different expressions in program 
>> indicators L
>>  
>> All the best,
>> Bernard
>>  
>> 
>> Bernard Sadaka
>> Information Management Advisor
>> Première Urgence - Aide Médicale Internationale
>> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>> Ain el Remmaneh, Beirut, Lebanon
>> E-mail: lib@pu-ami.org <mailto:lib@pu-ami.org>
>> Cell: +961 71 004 881 (208)
>> Skype: imapuami
>> Website: https://www.pu-ami.org <https://www.pu-ami.org/>
>>  
>>  
>

Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in Program indicator expressions

[Bernard Sadaka (IM Advisor)]

Hello Markus,

Thank you for the list and explanation; is there any expected timeline for 
that? (JIRA issue, I can track?)



With regards to the number of decimals, even if set to zero at the program 
indicator and after running the analytics, the “pivot table” still shows the 
digits.



Regarding the expression, yes it is true, I’m rounding the constants, because I 
am actually creating a budget report and applying a discount rate on the 
individual cost of a specific PHCC activity and aggregating them using sum (so 
I am using one constant per cost of a PHCC activity and another for discount 
rate of all activities). I ended up using exact values in the constant instead 
of a discounted factor; after all, changing a discount factor is easier than 
changing 200 values individually when the discount rate changes. The reason for 
all this, is that with a discounted factor there is a need to round the values 
and disallow them to be cumulated in the sum of the aggregation in order to 
keep the report error free.

Hope the above explains my usecase: aggregating the data elements of a TEI and 
multiplying them by a cost constant and a discount factor. And yes the round 
functions in this case would be very beneficial.



Thank you again for your support.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Wednesday, February 7, 2018 9:52 AM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>
Cc: dhis2-us...@lists.launchpad.net; DHIS 2 developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in 
Program indicator expressions



Hi there Bernard,

We aim to support more and hopefully all the program rule functions in program 
indicators.

Unfortunately we are not there yet, and the list of supported functions in 
program indicators can be found here:

19.4.5. Reference information: Functions, variables and operators to use in 
program indicator expressions and filters 
<https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#program_indicator_functions_variables_operators>



Where did you get the wrong number of decimals? In the Pivot or in the 
Tracker/Event capture?



One question on your expression below, it seems you are trying to round off a 
constant from your defined constant values? Your use case I would have guessed 
is to round off a data element or tracked entity attribute value?



Best regards

Markus





6. feb. 2018 kl. 15:31 skrev Bernard Sadaka (IM Advisor) <lib@pu-ami.org 
<mailto:lib@pu-ami.org> >:



I found a similar issue on JIRA ( <https://jira.dhis2.org/browse/DHIS2-2734> 
https://jira.dhis2.org/browse/DHIS2-2734)



But still doesn’t explain why I can’t use different expressions in program 
indicators :(



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Dhis2-users [ 
<mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net> 
mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On Behalf Of 
Bernard Sadaka (IM Advisor)
Sent: Tuesday, February 6, 2018 3:53 PM
To:  <mailto:dhis2-us...@lists.launchpad.net> dhis2-us...@lists.launchpad.net; 
'DHIS 2 developers' < <mailto:dhis2-devs@lists.launchpad.net> 
dhis2-devs@lists.launchpad.net>
Subject: [Dhis2-users] Using program rule expressions in Program indicator 
expressions



Can anyone tell me why I can’t use program rule expressions in Program 
indicator expressions?

Functions like ceil, floor, round and others are very useful.



Also I tried to use the “Decimals in data output” in the program indicator 
details, it didn’t work.

Also I tried to simulate the round function using conditional modulo 
subtraction/addition (the pivot table keeps trying to load) :

C{eB6eQXKY8HA}*C{xGZ2I9aTeXX} -(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 + 
d2:condition('(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 >=50',1,0)



Thank you in advance.

Please advise.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 

Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in Program indicator expressions

[Markus Bekken]

Hi there Bernard,
We aim to support more and hopefully all the program rule functions in program 
indicators.
Unfortunately we are not there yet, and the list of supported functions in 
program indicators can be found here:
19.4.5. Reference information: Functions, variables and operators to use in 
program indicator expressions and filters 


Where did you get the wrong number of decimals? In the Pivot or in the 
Tracker/Event capture?

One question on your expression below, it seems you are trying to round off a 
constant from your defined constant values? Your use case I would have guessed 
is to round off a data element or tracked entity attribute value?

Best regards
Markus

> 6. feb. 2018 kl. 15:31 skrev Bernard Sadaka (IM Advisor) :
> 
> I found a similar issue on JIRA (https://jira.dhis2.org/browse/DHIS2-2734 
> )
>  
> But still doesn’t explain why I can’t use different expressions in program 
> indicators L
>  
> All the best,
> Bernard
>  
> 
> Bernard Sadaka
> Information Management Advisor
> Première Urgence - Aide Médicale Internationale
> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
> Ain el Remmaneh, Beirut, Lebanon
> E-mail: lib@pu-ami.org 
> Cell: +961 71 004 881 (208)
> Skype: imapuami
> Website: https://www.pu-ami.org 
>  
>  
> From: Dhis2-users 
> [mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net 
> ] On 
> Behalf Of Bernard Sadaka (IM Advisor)
> Sent: Tuesday, February 6, 2018 3:53 PM
> To: dhis2-us...@lists.launchpad.net ; 
> 'DHIS 2 developers'  >
> Subject: [Dhis2-users] Using program rule expressions in Program indicator 
> expressions
>  
> Can anyone tell me why I can’t use program rule expressions in Program 
> indicator expressions?
> Functions like ceil, floor, round and others are very useful.
>  
> Also I tried to use the “Decimals in data output” in the program indicator 
> details, it didn’t work.
> Also I tried to simulate the round function using conditional modulo 
> subtraction/addition (the pivot table keeps trying to load) :
> C{eB6eQXKY8HA}*C{xGZ2I9aTeXX} -(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 + 
> d2:condition('(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 >=50',1,0)
>  
> Thank you in advance.
> Please advise.
>  
> All the best,
> Bernard
>  
> 
> Bernard Sadaka
> Information Management Advisor
> Première Urgence - Aide Médicale Internationale
> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
> Ain el Remmaneh, Beirut, Lebanon
> E-mail: lib@pu-ami.org 
> Cell: +961 71 004 881 (208)
> Skype: imapuami
> Website: https://www.pu-ami.org 
>  
>  
>  
>  
> 
> 
> Virus-free. www.avast.com 
> 
>  
> ___
> Mailing list: https://launchpad.net/~dhis2-devs 
> 
> Post to : dhis2-devs@lists.launchpad.net 
> 
> Unsubscribe : https://launchpad.net/~dhis2-devs 
> 
> More help   : https://help.launchpad.net/ListHelp 
> 

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in Program indicator expressions

[Bernard Sadaka (IM Advisor)]

I found a similar issue on JIRA (https://jira.dhis2.org/browse/DHIS2-2734)



But still doesn’t explain why I can’t use different expressions in program
indicators :(



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib@pu-ami.org 

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.pu-ami.org 





From: Dhis2-users
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On
Behalf Of Bernard Sadaka (IM Advisor)
Sent: Tuesday, February 6, 2018 3:53 PM
To: dhis2-us...@lists.launchpad.net; 'DHIS 2 developers'

Subject: [Dhis2-users] Using program rule expressions in Program indicator
expressions



Can anyone tell me why I can’t use program rule expressions in Program
indicator expressions?

Functions like ceil, floor, round and others are very useful.



Also I tried to use the “Decimals in data output” in the program indicator
details, it didn’t work.

Also I tried to simulate the round function using conditional modulo
subtraction/addition (the pivot table keeps trying to load) :

C{eB6eQXKY8HA}*C{xGZ2I9aTeXX} -(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 +
d2:condition('(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 >=50',1,0)



Thank you in advance.

Please advise.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib@pu-ami.org 

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.pu-ami.org 











Virus-free.
 www.avast.com





---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp