Aggregated Data

[dunnalahk123]

Hi,

Can some one help me writing below Aggregated function

i have metric which i am writing below aggregated expression

Project ID	E2E TAT	Days	Sch Days	E2E TAT HOLD
PR-368355	309	189	19	101
PR-380629	268	37	-	231
	288.5	113	19	166

For E2E TAT Metric :

=Num(Avg(Aggr(Avg([E2E Deployment TAT]), [E2ETATPROJECTID])),'#,##0' ) >>>> it works fine

Days:

=Num(Avg(Aggr(Avg([Days]), [E2ETATHOLDPROJECTID])),'#,##0' ) >>>> it works fine

Sch Days:

=Num(Avg(Aggr(Avg([SCHDays]), [E2ETATHOLDPROJECTID])),'#,##0' )  >>>> it works fine

For E2E TAT HOLD:

=Num(Avg(Aggr(Avg([E2E Deployment TAT – Hold]), [E2ETATHOLDPROJECTID])),'#,##0' )  >>>> it works fine

BUT for E2E TAT HOLD Calculation is

E2E TAT - (Days+Sch Days)

so from above table box

E2E TAT HOLD per individual project ID it works fine

309 - (189+19) =101

268- (37)=231

but when it comes to total

288.5 -(113+19) i am getting 166 as per my

Num(Avg(Aggr(Avg([E2E Deployment TAT – Hold]), [E2ETATHOLDPROJECTID])),'#,##0' )

but it should get  156.5

how can i write