Hi all,

My brain is not functioning with this problem: I have a price field that I want to change based on a quantity field. If the quantity is less than 2 then I want it to be $20, if it is less than 24 and greater than 2 then the price should be $18, if the price is greater than 25 the price should be $15. Any help is greatly appreciated.

Thanks,

Chris

NetPrice (calculation, number) =

Case(

Qty < 2, 20,

Qty < 25, 18,

15)

In your requirement you mention "less than 24 and greater than 25", remember that this specification doesn't indicate what to do with 24 and 25! How about "less than 25 and greater than or equal to 25"? You must be careful to be exact, these sorts of errors can be hard to find in a finished solution!

-bd

I tried to use the formula, but FileMaker tells me it can't find "that field" and thinks the comma and numbers are fileds.

I even used the exact syntax out of the FileMaker help and it doesn't work.

Any suggestions?

If you have a localized version of FM, the separator may be ';' instead of ','.

This occurs with our italian version and for other european localizations.

Check it & regards.

What is the name of your quantity field? Whatever it is, use it in the calculation instead of "Qty".