+ Start a Discussion
Johan Emerén 2Johan Emerén 2 

Monthly Opp Value With Ramp

Hi,

I got some help to build this neat little formula which calculates the value from the estimated live date until the end of the year. However, the value is what we expect to get out of the customer at month 6.

Would it be possible to take this into consideration when calculating the amount?

Amount * (( DATE(YEAR(Estimated_Live_Date__c),12,31) - Estimated_Live_Date__c ) / 30)

Approximate ramp is as follows

10%
20%
40%
60%
80%
100%