topic Re: Aggr by field event with one single value applyed in App Development

Aggr by field event with one single value applyed

IVAN-FELIPE — Thu, 23 May 2019 08:54:50 GMT

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 — Thu, 23 May 2019 12:12:58 GMT

Try adding your set analysis to the outer Aggregation also

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

IVAN-FELIPE — Tue, 28 May 2019 14:35:55 GMT

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

Thanks!