Apex Code Development You need to sign in to do that
Don't have an account?
Book_Guy Look up Field Based on a number
Have A Commission Rate Object:
Sales-$ Rate
1 10%
2 12%
3 14%
4 16%
* Oversimplified version - it will actual start at .01 and go throught 9,999.99
Want to link it to the Opportunity Object. So if Sales are $2, Rate = 12%. Is there a better way to do this other than creating a a look field based on the Sales-$?
You can try creating a custom setting (key-value pair concept) , and set the value in a trigger when the record is saved.
Did you try an Formula Field??
You can use an "Case" formula and you could get an Percent value