+ Start a Discussion

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