• Matthew Reznick
  • 0 Points
  • Member since 2014

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 2
I have a formula field that I need to fix.
current field:  Amount_Minimum__c / Contract_Terms__c

The Contract_Terms__ is an incorrect field and needs to be changed...here's the tricky part
The field I need to change it to is a picklist field
and to top it off it's not a numberical field.

Picklist values
1 Month
2 Months
3 Months
etc up to 18 months. 

So basically I need help building a formula field that allows one field to be divided by the value in the picklist; but the picklist needs to be changed to a number.  I hope this makes sense; can anyone help?