Jump to content
Sign in to follow this  
drschilling

Simple Script to set minimum and maximum commissions on a sale

Recommended Posts

I have commissions that range from a few pennies to hundreds of dollars.

I calculated the commissions with a simple formula and it gives me the commission amounts.

I want to set a minimum commission of, say $15 and a maximum commission of $75.

I used this: If ( BRBW Comm < 15; 15 ) and got all commissions < 15 to be set at 15.

However, I wasn't able to add to that the part about if the commission is > 75, set all those to $75.

Not sure what to use the Case or the If statement.

Also, I would like to learn more about using scripts.

Can you suggest a good resource for quickly learning scripting formulas?

Thanks very much!

David

Share this post


Link to post
Share on other sites

Try:


Case (

BRBW Comm < 15 ; 15;

BRBW Comm > 75 ; 75;

/* Else */ BRBW Comm

)

Share this post


Link to post
Share on other sites

If the minimum commission is 15 then there will be none < 15. If the maximum is 75 there will be none > 75.

Share this post


Link to post
Share on other sites

Try =

Case (

commission < 15 ; 15 ;

commission > 75 ; 75 ;

commission

)




or =




Min ( Max ( 15 ; commission ) ; 75 )






---

BTW, this is a calculation, not a script - and it could be done all in the same field, say =




Min ( Max ( 15 ; <your commission formula> ) ; 75 )

Edited by comment
  • Like 1

Share this post


Link to post
Share on other sites

Hi dr, and welcome to the forum,

Give us more detail regarding your breaking points.

0 - 15 = 15

16 - 25 = 25

26 - 50 = 50

and so on.

Lee

Share this post


Link to post
Share on other sites

Thanks very much for the quick response! I really appreciate it.

I need to think about this a bit . . . about the different levels that would be most suitable . . . will post later

Share this post


Link to post
Share on other sites

Hi,

 

I've been using this:

 

Case (
BRBW Comm < 15 ; 15;
BRBW Comm > 75 ; 75;
/* Else */ BRBW Comm
)

 

But I want to change it to this:

 

If price is $0 to $15 commission is $5

$15-$30, $7.50

$30-$50, $10

etc.

 

and then when I get to $250 I want it to be a percent and not a fixed $ value:

 

$250-$500, 15%

$500-$1000, 20%

>$1000, 25%

 

Not sure how to up these ranges.

 

Thanks for your help!

 

David

Share this post


Link to post
Share on other sites
Case (
	price < 0 ; "?" ;	// error
	price ≤ 15 ; 5 ;
	price ≤ 30 ; 7.5 ;
	price ≤ 50 ; 10 ;
	// ...
	price ≤ 250 ; 30 ;	// value "30" for example
	price ≤ 500 ; price * .15 ;
	price ≤ 1000 ; price * .2 ;
	/* Else */ price * .25
)

Share this post


Link to post
Share on other sites

It probably shouldn't be a script or calc at all; but rather a lookup from a commission rate table.

  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    adyf 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.