Skip to main content
Solved

Best way to Build out Commissions

  • 21 June 2023
  • 1 reply
  • 76 views

Hi All

Im trying to build out the company commissions based on NRR.
I want to be able to calculate the corresponding commission % based on the NRR we have forecasted

So each NRR% is equivalent to a Commission %. eg. 80-85% NRR = 0.05% commission. 86-90%=0.1% Commission and so on.

There are 8 bandings, so If statements seems quite long winded, but possible that way. Wondering if someone can think of an easier way?

Thanks!
 

Hi Adhain,

 

this is what we call a bucket/bracket/cluster logic. Often used for tax rate and commissions indeed.

here’s an article that talks about it 

Sorting data in clusters | Community (gopigment.com)

Take a look and then we’ll support your logic if you need

Reply


Ask your question here!

Terms & ConditionsCookie settings