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.

 

Regards,

George

Actions