2 Replies Latest reply on Feb 8, 2010 3:17 PM by comment_1

    Calculating quantity discount



      Calculating quantity discount


      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.