1 Reply Latest reply on Jul 23, 2010 4:42 PM by philmodjunk

    Formula Help



      Formula Help


      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.

        • 1. Re: Formula Help

          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.