Problems with AGGR

[Anonymous]

Hi everybody.

I hope you can help.

this is my table:

IDDEVICE     DATETIME    PAC     IDPARK

1                    2012-02-14     5          1

1                    .....                7          1

1                    ......               1          1

2                    .....                   2          1

2                    .....               9          1

3                    .....               11          1

ecc.

In a graph i have chose IDDEVICE as Dimension.

In wrote this expression : Avg( Aggr((if(PAC>0,PAC)),IDPARK)) because for each IDDEVICE i want to calculate the Avg of every PAC(also from different IDDEVICE) but doesn't work.

My complete expression is :

Avg( {<[PAC]= {"=[PAC]>0"}>} [PAC])

/

Avg( Aggr((if(PAC>0,PAC)),IDPARK))

Thanks

[CELAMBARASAN · Accepted solution]

Hi,

     I think you this kind of expression.

     =Avg( {<[PAC]= {"=[PAC]>0"}>} [PAC])/Avg(TOTAL  {<[PAC]= {"=[PAC]>0"}>} [PAC])

Celambarasan

[jagan]

Hi,

Try the below expressoin

=Sum( {<[PAC]= {">0"}>} [PAC])/Count(TOTAL  {<[PAC]= {">0"}>} [PAC])

Regards,

Jagan.

[Anonymous]

Celambarasan,I think you read minds

Thanks,

both of you