Calculating the sum of max values in aggregated data

How can I calculate the sum of max values in aggregated data. In my example, I enter data for all organizational units on a monthly basis. As this is data collected on the same participants, I wanted to calculate the max for each organizational unit (i.e. take the month in which several people were affected by the activity), and then add up all the max values for the different organizational units.
In my screenshot, I’d like the total to be the max.

Any ideas?

2 Likes

Hi @johnntab

Welcome to the DHIS2 Community!

For this issue, you can use an indicator and the aggregation type ‘MAX’. This will give you the MAX value for each OU.

1 Like

Thank you Gassim.
What is the syntax for calculating the max with an indicator?

Best

1 Like