You need to sign in to do that
Don't have an account?
Jin 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!
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!