Getting sum of a aggregated field based on 2 other fields.

Dylangkx — Thu, 11 Apr 2024 05:01:53 GMT

Hi all,

I'm trying to obtain a sum of an aggregated field by 2 different fields (Country and Unique ID)

The base field that I am trying to sum up is as follows:

Count({<[Vehicles] = {1}>} distinct Unique_ID1 & Unique_ID2

I have tried to use this formula

Sum(Aggr(Sum( (Count({<[Vehicles] = {1}>} distinct Unique_ID1 & Unique_ID2))), Unique_ID2, Country))

but it seems to return me only 0s for the whole column. Would appreciate if there are any solutions to this or if anyone needs clarifications on the question!

Re: Getting sum of a aggregated field based on 2 other fields.

BrunPierre — Thu, 11 Apr 2024 09:04:21 GMT

Try

Sum(
Aggr(
Count({<[Vehicles] = {1}>} distinct Unique_ID1 & Unique_ID2)
, Country, Unique_1D2)
)

topic Re: Getting sum of a aggregated field based on 2 other fields. in App Development

Getting sum of a aggregated field based on 2 other fields.

Re: Getting sum of a aggregated field based on 2 other fields.