Revenue Calculation

Hi All,

    We have a new requirement where we need to caculate revenue based of two date fields and show the amount in reports. I have the below new fields.

    Revenue % 

    Revenue Amount

    Expected Date

    Repayment Date

    Revenue Amount

The revenue amount should be calculated based on the difference between Repayment Date and Expected Date. Example as below.

Revenue % - 1

Revenue Amount - 1 billion

Expected Date - Sep 10 2013

Repayment Date - Nov 5 2013

Now Revenue Amount calculation will be as below

For September - 1% *1 billion * (20 days remaining in september - based on difference between expected date and repayment date)

For October - 1% *1 billion * (31 days in October  - based on difference between expected date and repayment date)