Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I been trying to show on a graphic the count of a certain information.
Example:
WIN | MANUFACTURE |
---|---|
100 | PRO A |
78 | PRO B |
125 | PRO C |
183 | PRO B |
25 | PRO C |
I put if (avg(WIN)*1.20>=avg(WIN), count (MANUFACTURE),)
The result always will be 5 (the count if MANUFACTURA rows).
What I need is that only count the amount of manufactures that are above the average by 20%.
On the Example the average will be 102.2 and the total manufactures above average will be 2.
I think the problem is what i have to put instead of count (MANUFACTURE).
Hope you can help me.
REGARDS
Hi Carlos,
You could do this:
COUNT(IF(WIN >= AVG(TOTAL WIN) * 1.2, MANUFACTURE))
Hi Carlos,
You could do this:
COUNT(IF(WIN >= AVG(TOTAL WIN) * 1.2, MANUFACTURE))
Use expression as below:
=count({1<WIN ={">=$(vAverage)"}>}MANUFACTURE)
vAverage is a variable with expression =avg({1}WIN)*1.20
Hi,
Try with this,
=Sum(Aggr(If(Avg(WIN)>=(Avg(TOTAL {1} WIN)*1.20),1,0),MANUFACTURE))
Hope it helps
Celambarasan
Try this
=sum(if(WIN1>$(v),1,0))
=Avg(WIN1)*1.2
Thanks for your help