Contract Term (Months) with Custom Fields

Question

Hi SF Community,

I am running into a problem when calculating the Total Contract with custom Opportunity Fields. See Below:

Contract Term (Months) with Custom Fields

In this example, how we price currently is # of month * PEPM 1.50 * Total Lives Opportunities. However in this example the Partner Services and Support & Plan Design of 5K each only count for the first 12 months, rather than the full length 24 Contract. Does anyone have any suggestions on how to format these equations where Total Contract amount will account # of months with custom fields?

Thanks!

-Drew

CS Gan · Accepted Answer

Drew, ceiling function rounds up the figures. So it basically says, if you contract for 13 months, you still pay 24 months.

If your organisation is okay with pro-rating, the below formula will work fine.

((PEPM__c  *   Total_Lives_Opportunity__c ) *  Contract_Term_of_Yrs__c) +  Plan_Design__c  +  ((Contract_Term_of_Yrs__c / 12) * Partner_Services_and_Support__c)

Let me know if it works.

Cheers,

CS

CS Gan · Answer

Drew,   correct me if I am wrong but your current forumla looks like this (Contract Term * PEPM * Total Lives Opportunities)+Partner Services Support + Plan Design   Plan Design should be an once-off fee where as Partner Services Support is recurring?   What happens when the contract terms falls anywhere in between a year? (e.g. 18 months)   Below's example includes a Ceiling Function where it rounds up the number of months to the highest value of year (i.e. 1.5 years will be rounded to 2 years). (Contract Term * PEPM * Total Lives Opportunities) + Plan Design +  (CEILING(Contract Term / 12) * Partner Services Support) If you're pro-rating the Partner Services Support, just remove the ceiling function and you're good to go.   Let me know if you have any further questions.   Cheers,   CS

Contract Term (Months) with Custom Fields

Sales And Marketing

관련 학습

도움 더 받기