function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jin Kaur 7Jin Kaur 7 

MRR calculation for report depending on length of Deal

Hi,
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.

Thanks!