Average Calculation - Set Analysis

[Anonymous]

Dear Team,

Need your help in set Analysis.

I would like to calculate the average time for each teams excluding the zero hours count.

Kindly refer the "avg calculation" file.Here in row 15 I have updated the required results.The average should be based on only the time which are greater than zero.I have highlighted the greater than times in Green.

If you see "Team3" average it is 16:15,however if we go by only the considered hours(>0) it comes to 32:30.

Could you please help me in arriving the required numbers by set analysis

I am attaching the sample qv file with raw data also for your kind reference

Thanks & Regards

Jeba

[Anonymous]

Dear Team,

Could you please help.

Thanks & Regards

Jeba

[#3]

Hi,

you could use the below expression.

sum(Time)/count(if(Time>0,1,0))

[lironbaram · Accepted solution]

have a look

at the attach example , hope it helps you

[Anonymous]

Hi Liron,

Its working perfect.

Great and thanks a lot for youe immediate reply

Thanks & Regards

Jeba