Average TAT

[#1]

Hi All,

I need to calculate the Average of for (Payment_Sent_Date - LDR ) as shown in image. How can i calculate Average of Days between Payment_sent_date and LDR. From Given Snapshot Average should be as (1+2+1+2+0+1+1+2+2)/9 from No_Of_Days field.

Kindly Reply

[Gysbert_Wassenaar]

avg(No_Of_Days) would be my guess.

[#3 · Accepted solution]

Depends on what you want.

AVG(No_Of_Days) to calculate the average over all records

or Avg(Aggr( AVG(No_Of_Days),Contract_number)) to calculate the average you seem to want.

This aggregates the values per Contract_number and then calculates the average.

AVG(No_Of_Days) will give you (28*0 + 96*1 + 96*2)/(28+96+96) or if you look at it from the Contract_number 24*1 + 24*2 + 24*1 + ... etc.