+ Start a Discussion
Jin Kaur 7Jin Kaur 7 

MRR calculation for report depending on length of Deal

The standard revenue scheduling rounds up the values when split into monthly revenue schedules and this shows incorrect values/ month.
I would like to show the actual revenue amount to 2 decimal places/ month.
I see the calculation something along the lines of
End Date - Start Date (custom fields which currently calculate "Months__c")
Divided into Total Amount on the Opportunity.
How do I get it to populate into the revelant months (if i mimic the revenue schedule fields by custom fields Jan-Dec)??
And to show this in a report too.