Average Calculation

Ramco Ramco

3y891SQL

I have below query & i want to get average by dividing total no days by total no of entries

select sum([TotDays]),month([InvoiceDate]),year([InvoiceDate]) FROM [Sales]
where [InvoiceDate] between DATEADD(month, -12, GETDATE()) and GETDATE()
group by year([InvoiceDate]),month([InvoiceDate])

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar3y ago

Accepted answer

Hello,

Please use this query,

select isnull(sum([TotDays]),0)/count([InvoiceDate]) as Average,sum([TotDays]) as TotDays ,month([InvoiceDate]),year([InvoiceDate]) FROM [Sales] 
  where [InvoiceDate] between DATEADD(month, -12, GETDATE()) and GETDATE()
  group by year([InvoiceDate]),month([InvoiceDate])