A Different Sliding Scale

[adam19ku]

We use a sliding scale to charge our customers for shipping. I have been playing with different implementations of this and have gone as far as writing a really long calculation field, but there's gotta be a better way.

I've attached an image of our sliding shipping scale. It's pretty straight forward until your order reaches $300 and then you start adding percentages.

I'm using this data as part of a database to calculate item costs. I'd like to be able to select the shipping method (in a Shipping Method field) and then have it use the data in my Price field to retrieve the related shipping charges from the table (attached).

Can anyone lend a hand?

[comment]

Try it this way?

LookupChargeOrPercentage.fp7.zip

[adam19ku]

Thanks so much. I was making it entirely too complicated!