Hi Everyone, I need help with creating a custom formula on an opportunity. Background: My company sells training services, which can be delivered anytime after the close date of the opportunity. Our definition of ACV, is the value of training that is delivered within 12 months of the close date. Aim: I would like a field on the opportunity that automatically calculates the ACV of the deal. Details: We have three existing fields on an opportunity that will need to be used in a formula to give me a value for ACV... - Close date - This is straightforward - Delivery date - This is the delivery start date - Total Value of opportunity I would like to create a custom, formula field that looks at the Delivery date to see if it is less than 12 months away from the close date. If yes - Put the full value of the deal into the ACV field If no - Put $0 into the ACV field Any idea how if I can do this with a custom formula field or would I need to use Flow? Help on either solution would be appreciated. Thanks, Dan
2 answers
