topic Re: Aggr Only not working when filtering a field in App Development

Aggr Only not working when filtering a field

gitguto — Fri, 16 Sep 2022 17:30:45 GMT

Hello everyone, I have a dimension in which I show only the components that are part of the Material A:

=Aggr(Distinct Only({<Material = {'A'}>} Component), Component).

This works perfectly if I dont filter any other field.

However, when I filter another field "[Material Group]" for example, my aggr dimension returns only null values.

I've already tried these two approaches but they dont work:

=Aggr(Distinct Only(1{<Material = {'A'}>} Component), Component).

=Aggr(Distinct Only({<[Material Group]=,Material = {'A'}>} Component), Component).

Thank you

kaushiknsolanki — Fri, 16 Sep 2022 18:32:15 GMT

Try this

Aggr({1}Distinct Only({1<Material = {'A'}>} Component), Component).

gitguto — Fri, 16 Sep 2022 18:40:03 GMT

Thanks for your reply, it didn't work. It also returns null values.

BrunPierre — Sat, 17 Sep 2022 08:04:58 GMT

Hi,

Try these expressions

Aggr(Distinct Only(Total{<Material = {'A'}>} Component), Component)

Maxstring({<[Material Group]=>} Aggr(Distinct Only({<[Material Group]=,Material = {'A'}>} Component), Component))