Can this be done?

[kendallj10]

I want to be able to calculate a shipping price total, based on preset prices, but these prices vary depending on weight. How do I add a calculation that figures the weight of the shipment and then calls the appropriate price for that weight? I have not been able to figure this out. I am using Win NT, Filemaker Pro 3.0

Thank you in advance

[LiveOak]

To give you an exact answer, we'll need a little more information about the calculation you want to implement and a description of you file structure. The general idea is to use a calculation:

Shipping Cost (calculation, number) =

Case(

Weight <= 1, ShipPrice1,

Weight <= 3, ShipPrice2,

Weight <= 6, ShipPrice3,

.

.

.

DefaultShipPrice)

The Case() statement takes the value from the first test that succeeds. The second test doesn't need to be "Weight > 1 and Weight <= 3" because if weight > 1, the first test would have succeeded.

-bd

[kendallj10]

Thank you for your response - a little more information - maybe that will help

if i want to set fedex's prices into my system, for example, each zip code set has its own "zone" and each zone has a corresponding price (i.e.

zone 2 for 1 lb. = 41.25

so i need a formula that will determine, zone based on zip code, multiply by weight and determine price. I guess i'm wondering if THAT is doable - that might be significantly more complicated. What do you think?

[Vaughan]

It's doable, but a hell of a huge calcualtion! And all the values will be hard-coded into the calculation so when they change their schedule somebody needs to edit the field.