Jump to content
Sign in to follow this  
skingjack2

implement a variable commission rate calc

Recommended Posts

Hello all,

Any quick thoughts on how one would go about implementing a variable commission rate calc. i.e. each product sold has different commission rates. I'm envisioning a solution where once a

total value is entered into a field, another window would pop-up where you would choose the appropriate commission value and then the calculation would execute with the final result

placed in another field. Creating a new display

is not an issue; it's just integrating the calc with the display is the stumbling block. As with our questions I've posed, there always seems to be more than 1 way to accomplish things in FM...I'm open to other suggestions/ideas.

TIA

Jack

Share this post


Link to post
Share on other sites

Hi,

Did a little more searching in the forums and I think I may have found another solution though not quite what I envisioned that will work .

(thanks comment for your related value file)

Jack

Share this post


Link to post
Share on other sites

I am not sure which file/thread you are referring to, but it sounds like in this case a lookup would be more appropriate than using a related value directly. This way, if a product's commission rate changes, previously created sale records will not be affected.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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