2 Replies Latest reply on Aug 15, 2010 7:40 PM by Indy14

    Rounding Question

    Indy14

      Title

      Rounding Question

      Post

      I'm using the Filemaker 11 Pro & FileMaker supplied Invoice example. I have line items that are as follows:
      Qty 4992 price .01 extended price 49.92
      Qty 4992 price .002 extended price 9.98 (actually 9.984 in Excel)
      Qty 5312 price .002 extended price 10.62 (actually 10.624 in Excel)
      I get a total of 70.53 It should be 70.52. (actually 70.528 in Excel)
      It shouldn't be rounding up on 3 decimal places.
      What do I need to change?