function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Book_GuyBook_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-$?

DonSpilkyDonSpilky

You can try creating a custom setting (key-value pair concept) , and set the value in a trigger when the record is saved.
MayeUPAEPMayeUPAEP

 

Did you try an Formula Field??

You can use an "Case" formula and you could get an Percent value