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 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
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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
      ------------------------------