Formula Needed so that ACV Custom Field is Equal to Amount when # Months is

Question

Hello,

I need help writing out a Validation Rule for our 'ACV' custom field based on the 'Number of Months' custom field on the Opportunity records.

So currently my ACV equation is

ACV = Amount * (Number of Months / 12)

And that works out great. However, if the 'Number of Months' is less than 12, then I need the ACV to equal the Amount.

Thanks!

Eric Praud · Accepted Answer

Actually, are you looking for a validation rule, or is it a formula field that needs to calculate ACV = Amount * (Number of Months / 12) except if the number of months is less than 12, in which case it shoudl be ACV = Amount?

If the latter, then try this:

IF(Number_of_Months__c<12, Amount, Amount * Number_of_Months__c / 12)

Tommaso Bolis · Answer

Amount*  (   IF(     Number_of_Months__c<12,      Number_of_Months__c,      12   )/    12 )

Formula Needed so that ACV Custom Field is Equal to Amount when # Months is < 12

Data Management

Risorse di formazione correlate

Ulteriore assistenza