# Calculating quantity discount

Question asked by Brockway on Feb 8, 2010
Latest reply on Feb 8, 2010 by comment_1

### Title

Calculating quantity discount

### Post

I have only used Filemaker a few times over the years and need help with a calculation that is probably fairly easy. I am trying to create a digital Filemaker version our paper order sheet. In each line of the order sheet it lists how many of a product is ordered, the price and then the total. What I'm stuck on is if a customer orders a certain quantity of an item, the price goes down. For example, if they order 8 widgets the price is \$2.50. If they order 12 or more the price is \$1.99. How do I make a calculation for that?

In this example 8 is from a field called "qty.", \$2.50 is from a field called "each", 12 is from a field called "buy", and  \$1.99 is from a field called "pay". The total will be in a field called "total price"

Don't laugh, I know this is totally wrong, but this is what I tried so far. This is what I tried for a calculation for the filed "total price":

if Qty.<Buy = Qty. * Each

if Qty. ≥ Buy=Qty. * Pay

What am I doing wrong?

I am using Filemaker Pro 6 (yes I know it's old) on Mac OS X 10.6.2. This will only be used by me and will not be on a network or online.

Thank you.