Skip to Content
0
Former Member
Mar 25, 2009 at 08:04 AM

Reporting requirement to calculate averages based on Calendar days

25 Views

Can someone help with this?

I have a set of reports to display daily, weekly, monthly and yearly data. There is a KF used in the report having the following requirement.

The overall result and individual results (in case of weekly monthly and yearly report) should be displayed as an average wrt calendar days in the current period.

eg if the user executes the monthly report on say 15th march, the report should calculate the average only for 15 days. Currently the report is displaying the average for 31 days (it takes the total no of days in march). the same goes for yearly report.

I have used excepition aggregation of average based on calendar days for this calculated KF which is responsible to do the above calculation.

I have been asked to create a user exit to achieve the above requirement. But I am relatively new to ABAP programming. So any documents to do the same is also welcome

Thanks in advance.