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