← Back to team overview

dhis2-users team mailing list archive

Re: Create Program indicator to sum DE across events

 

Hi there Joao,
At the moment this is not possible to do within standard DHIS2 functionality. We are working on a change that might enable this kind of calculation, but this is not detailed and planned to a specific release yet.

It would be possible to make a custom SQL view that retrieves this. This option is a bit more advanced.

Best regards,
Markus

> 22. mai 2017 kl. 10.03 skrev Joao Machiana <joaomachiana@xxxxxxxxx>:
> 
> Hi community members
> 
> ​I'm creating a Tracker form, which has 2 stages: one is non-repeatable and the other one is repeatable
> 
> I need to create an Indicator that takes data from a DE from the non-repeatable stage and subtracts the sum of a particular DE from the repeatable stages (all events). Something like this:
> 
> Indicator = {NonRepatableStage.DataElement1} - SUM{RepeatableStage.DataElement2}
> 
> What I'm getting is the Indicator takes the value of the last event, but I actually want the sum of the values of a particular DE of the events (repeatable stages)
> 
> 
> Best regards
> 
> 
> -- 
> João X. Machiana
> Systems Analyst and Programmer
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp


References