You need to sign in to do that
Don't have an account?
Need help with simple formula
Hi, We recently moved our CRM to sales force, I have found everything pretty easy and straight forward. However I have a issue inside the opportunity column. Basically we have a pick list for Probability it is set in percentages 10% 20% 30% etc I'm basically trying to multiply field based on whatever percentage they select.
I know pick lists have issues with being used in formulas here is what I am trying to do
RandomNum * Value(text(Prcentagepicklist))
Basically I get #err . If I do what I believe the math would be I don't see how the system is messing this up but I really don't know to much about how sales force manipulates values.
Can some help me see if they can produce a value. The randomnum is a currency normally like 200,000.
Are you using the standard probability field, when probability is 50% then a numeric formula field Probability * 150 = 75