The owner of my company is looking for FM to figure out commission structures. We currently have all of our products in FM and they are split up into 9 tiers. We would like a formula that allows us to type in the dollar amouns sold and the sq ft amount sold and have FM tells us that it falls between Tier 1 and 3 and the sales person should receive x%.
Below is what he emailed me.
(10,000 Dollars sold)/1000 (Sqft Sold) = 10.00 a sqft
that sqft price would be evaluated against the sales price tiers in the database and return a commission percent earned.
Any suggestions how to write it.
You can enter these 9 tiers into a lookup table. Using the looked up table with the right relationships and options, ( you may need to select the copy next higher or copy next lower value options) and you should be able to copy the appropriate value into a field where you can use it to calculate the commission.