topic Re: Nested aggregation not allowed in App Development

Nested aggregation not allowed

mamar910 — Fri, 19 Feb 2021 11:04:11 GMT

Hello

I want to count the number of companies that sell the product (1,2,3) ie the amout of sells>0.

I tried sum(if($(Amount)>0,1,0)), but doesn't work because of nested aggregation.

There'is an example of my data :

Thank's for you're help

agigliotti — Fri, 19 Feb 2021 11:13:01 GMT

So in your case what should be the expected result?

GaryGiles — Fri, 19 Feb 2021 11:14:25 GMT

I'm not sure what is in your variable $(Amount), but I am assuming it is something like sum(Product 1) or sum(Product 2).

To count Companies that sell a particular Product, you could use:

count({$<Company={"=sum([Product 1])>0"}>} Distinct Company)

If you are using a variable to change the product you are looking for, you would need to fit it into this expression.

If the Amount variable contained [Product 1], [Product 2], or [Product 3], it might look like:

count({$<Company={"=sum($(Amount))>0"}>} Distinct Company)