Forum Discussion

TerriBruce's avatar
TerriBruce
Qrew Cadet
3 years ago

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

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 Commissio...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
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's avatar
TerriBruce
Qrew Cadet
3 years ago
Thank you for letting me know.

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