Please help with one script

[#1]

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

[#2 · Accepted solution]

Hi Carlos,

You could do this:

COUNT(IF(WIN >= AVG(TOTAL WIN) * 1.2, MANUFACTURE))

[#3]

Use expression as below:

=count({1<WIN ={">=$(vAverage)"}>}MANUFACTURE)

vAverage is a variable with expression =avg({1}WIN)*1.20

[CELAMBARASAN]

Hi,

     Try with this,

          =Sum(Aggr(If(Avg(WIN)>=(Avg(TOTAL {1} WIN)*1.20),1,0),MANUFACTURE))

Hope it helps

Celambarasan

[#5]

Try this

=sum(if(WIN1>$(v),1,0))

=Avg(WIN1)*1.2

[#6]

Thanks for your help