5 Replies Latest reply: Aug 21, 2012 3:15 PM by suresh kumar chandrasekaran RSS

Calculating the average usage for last 3 months

George Thomas
Currently Being Moderated

Hi Experts,


Need your help and suggestions for the below scenario:


I have a report with the fields: Customer, Average Usage in last 3 months and Usage in Current month.


Filter is on Month/Year. Month/Year field is a string at DB level.


Can you please suggest how to calculate the average usage for the last 3 months by taking the user input for the current Month/Year.