Partial average.

[#1]

Hello all, I am lee.

• I want to have partial average instead of partial sums    in example format.

I attached example.

please let me know.

Thank you so much

[#2]

as you can see,

Count(FABOUT_TM) make data different.

Sorry to bother you.~

[SunilChauhan]

as per you qvw ,i can see  on count distinct gives correct result

sum(TAT)/Count(distinct FABOUT_TM)

for example

11.59	0.18	1.76	17.93	6.33	12.16
0.70	0.10	1.99	16.45	3.51	1.03
0.65	0.13	1.87	18.94	6.24	1.05
0.63	0.16	3.48	17.84	2.17	1.04
0.44	-	0.78	21.31	1.04	0.04
0.41	-	1.17	33.59	1.83	0.04
0.43	-	0.78	9.35	0.19	0.12
0.50	0.10	1.08	14.69	2.13	1.24
0.45	0.11	1.02	11.31	2.00	0.92
0.39	0.07	1.02	11.41	1.61	0.93
0.58	0.09	1.03	10.68	1.67	0.97
1.52	0.12	1.45	16.68	2.61	1.78

calculate below averages it will show you correct figure

as i can see distinct value for LOT against devices

hope this helps

[#4]

um... i'll study cont.

anyway Thanks chauhans85~