40 Level Markup Table

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Looking for the best way to assign a markup % to individual records in an estimate item table.  Markup is based on the total cost, not based upon the product selected.  For example 5 pieces with a per item cost of $10 would get the same markup as 1 piece of a item that costs $50.  The markup is based on the $50 total in base cases.  Our markup table has about 40 levels in it.   Thanks. 
Photo of Roger Landis

Roger Landis

  • 130 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,784 Points 50k badge 2x thumb
Official Response
I suggest having a single standard markup table with the two columns being [Order Size] and [Markup].  It will also have a number from 1-40 which you would set as your Key Field to represent the Markup level. 

On the parent record you would would have a formula calculate which of the 40 markups to use based on yes, a 40 line IF statement.

Then you would pull in the correct markup to apply into the Parent record and then look that up to the child records..

When the order has been invoiced, you would then trigger a native Action to copy the values from the markup lookup value into the frozen lookup value so that it would not change if you changed your discount structure in the future.  so the formula for the markup would actually be to use the frozen value if there is one, else use the lookup, and that is what would be passed down to the child records.