Aggr by field event with one single value applyed

[IVAN-FELIPE]

Dear colleagues

I'm trying to apply a set analysis formula without success:

 - I need to apply the the property "one single selected value" to the field "Month"

- After that I need to make an expression like this :

  sum(Aggr(sum({<Month>}IssuesTime)/Sum({<Month>}Power),Month))

So I need to all the values by month and then sum each result, even when I have a single month selected.

I cannot use a floating calendar.

It seems to be simple but it does not work. The aggr by month ignore the rest of the months.

Any ideas?

Thanks a lot!

[sunny_talwar · Accepted solution]

Try adding your set analysis to the outer Aggregation also

Sum({<Month>}Aggr(Sum({<Month>}IssuesTime)/Sum({<Month>}Power), Month))

[IVAN-FELIPE]

This works, just needed to ignore the month selections in the sum previous to the aggr.

Thanks!