Help with calculated field (AVG)

Question & Answer
, ,
1

Given the following calculated fields:

Prom:
Sumif (qty_cust, name =‘Prom’)

Detr:
Sumif (qty_cust, name = ‘Detr’)

Calc1:
(Prom - Detr) /
qty_cust * 100

*The field qty_cust is quantity of customers from my table

I need to create a calculated field that brings the average of the 3 sec, but it is not working, I get an error that it is not allowed to calculate.
I tried using AVG, AVGOver, AVGif, SUMOver, Sumif, but it is not working either.

Sumif (Calc1, sec = ‘A’) +
Sumif (Calc1, sec = ‘B’) +
Sumif (Calc1, sec = ‘C’)
/ 3

Thank you so much.
July.

2

Hi @July

can so show us the error message?

I guess the issue is, that you try to aggregate a aggregation.

Is it possible to use countIf instead of qty and sumif?

Best regards
Nico

3

Hi Nico,

I also tried using the COUNTIF function, but the calculated field isn’t even created. It says that aggregating an aggregation is not allowed.

Any ideas?

4

Hi @July

can you share a screenshot and the formula?

Did you use countif to count the customers if the name equals “Prom” or “Detr”?

Best regards
Nico

5

Hi @July,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @July,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!