Any help with this solution is greatly appreciated!

Advertising company needs to report the Qtrly revenue amount, for ads running. More specifically: $Amount for deals with Prob > 50%, where the ad run date(s) encompasses X Qtr.

Here are the fields I have and an example:

• Amount $12,000.00 [standard field]
• Start Date 8/15/2011 [custom field created]  
• End Date 10/20/2011 [custom field created] 
• Number of run days: 67 [custom field: End_Date__c - Start_Date__c +1]
• daily rate: 179.10 [custom field: Amount / Number_of_Run_days__c]

Desired results for reporting:

Ref details for this example:

17 days (8/15/2011 -8/31/2011) 17*179.10= 3,044.78

30 days (9/1/2011-9/30/2011) 30*179.10= 5,373.13

20 days (10/1/2011-10/20/2011) 20*179.10= 3,582.09

Thank you for your time!

Karen