Monthly Earned

[hlmnsbuggy]

CR 2011, oracle
if I have policy premium, policy effective dates and expired dates, I need to report mtd earned premium by every month end. how can I do that?
data:
pol effectivedate expireddate premium
pol3 1/15/2013 1/15/2014 3600

report to show:
Beginning date month end month premium earned
1/31/2013 157.81
2/1/2013 2/28/2013 276.16
3/1/2013 3/31/2013 305.75
4/1/2013 4/30/2013 295.89
5/1/2013 5/31/2013 305.75
6/1/2013 6/30/2013 295.89
7/1/2013 7/31/2013 305.75
8/1/2013 8/31/2013 305.75
9/1/2013 9/30/2013 295.89

Thanks for your help in advance.
Ann

 

[LaurieHamlin]

Ann,
If I understand correctly, you would have to group on the month and create totals in the group footer. I hope that helps.
Laurie