1 Reply Latest reply on Jun 25, 2015 8:17 AM by TSGal

    how to round up numbers (not to 0,5)

    RossellaSpangaro

      Summary

      how to round up numbers (not to 0,5)

      Product

      FileMaker Pro

      Version

      FM Pro 14

      Operating system version

      Windows 7

      Description of the issue

      FileMaker "rounding" function is set to round up numbers to 0,5
      This means that 110,221 is rounded up to 110,22 and 110,226 is rounded up to 110,23.
      I want 110,221 to be rounded up to 110,23
      I'll appreciate your help very much!

      Steps to reproduce the problem

      I have tried to use the "Arrotondamento" function (I have the Italian version and guess it it correspond to a "round" function in English)
      but of course it does not work.

        • 1. Re: how to round up numbers (not to 0,5)
          TSGal

          Rossella Spangaro:

          Thank you for your post.

          The Ceiling function will round a number up to the next integer.  Therefore, assuming your field is named "Amount", the formula would be:

          Ceiling ( Amount * 100 ) / 100

          Using your example of Amount = 110,221
             Ceiling ( 110,221 * 100 ) / 100
             Ceiling ( 11022,1 ) / 100
             11023 / 100
             110,23

          Let me know if you need additional clarification.

          TSGal
          FileMaker, Inc.