Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I think you this kind of expression.
=Avg( {<[PAC]= {"=[PAC]>0"}>} [PAC])/Avg(TOTAL {<[PAC]= {"=[PAC]>0"}>} [PAC])
Celambarasan
Hi,
I think you this kind of expression.
=Avg( {<[PAC]= {"=[PAC]>0"}>} [PAC])/Avg(TOTAL {<[PAC]= {"=[PAC]>0"}>} [PAC])
Celambarasan
Hi,
Try the below expressoin
=Sum( {<[PAC]= {">0"}>} [PAC])/Count(TOTAL {<[PAC]= {">0"}>} [PAC])
Regards,
Jagan.
Celambarasan,I think you read minds
Thanks,
both of you