4 Replies Latest reply on Jan 8, 2015 11:53 AM by philmodjunk

    Bad display of percentages when representing a scientific notation number

    calexmac

      Summary

      Bad display of percentages when representing a scientific notation number & and CR

      Product

      FileMaker Pro

      Version

      13.0v4

      Operating system version

      MacOS 10.10.1

      Description of the issue

      If a field contains number represented in scientific notation AND the number is followed by a carriage return, e.g. 1.965311e-10CR, where CR is a carriage return, then the number is shown in a field as 196.531% when the field is set to display the number as a percentage and with 3 decimal points.

      This only happens when the number is followed by a CR.

      I believe in the example above that the field should display 0.000%
      This is because a number not expressed in scientific notation AND followed by a CR displays correctly as a percentage.

      Steps to reproduce the problem

      1
      Create a number field and set its value to this: 1.965311e-10CR (where CR is a carriage return)

      2
      Display the number in a field as a percentage, only showing the first three decimal places

      Expected result

      0.000%

      Actual result

      You see an incorrect number! = 196.531110000000%

      Also note the extra "1" before the string of zeros... probably from the "e-10".
      Whatever, its behaviour that is not consistent with the processing of other numbers with a following CR (which is simply ignored)

      Exact text of any error message(s) that appear

      No error message

      Configuration information

      Have only included 1 plug-in = BaseElements.  Everything else is as standard as possible.

      Workaround

      Easy enough:
      If using scientific notation...
      - Ensure that there is no following CR and
      - Force a rounding to less than 10 significant digits before storing the field.