Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
avg(No_Of_Days) would be my guess.
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.