Can I write a formula for a commission rate based on a User's Role?

Question

I have a Work Order table. The person who creates a Work Order receives a commission for the job on the work order. Formula: Work Order Price * Commission Rate. I'd like to have a different Commission Rate based on the User Role of the person who wrote the work order. For example: Sales = 10%, Rep = 7.5%. Is that possible?

------------------------------
Terri Bruce
------------------------------

markshnier__you · Answer

Sorry, but there is no function for that. You will need to have a table users and set the commission that way, pulling the Rate in on a lookup.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

terribruce · Answer

Thank you for letting me know.------------------------------Terri Bruce------------------------------

Forum Discussion

Can I write a formula for a commission rate based on a User's Role?