1 Reply Latest reply on Oct 3, 2012 2:14 PM by disabled_ntaylor

    'Max' of text field doesn't work in related records

    barefootguru

      Summary

      'Max' of text field doesn't work in related records

      Product

      FileMaker Pro

      Version

      11.0v4 and 12.0v2

      Operating system version

      OS X 10.8

      Description of the issue

      The manual for the 'max' function states 1. it works for text fields, and 2. it works over related records.

      However from my testing I've found while 'max' works for text fields within the same record, numeric fields in related records, but not text fields in related records.

      This would be consistent with the 'max' summary field which also can't process text fields.

      Steps to reproduce the problem

      table2 has:

      'key' as numeric, field1 as numeric, field2 as text

      first record:  key=1, field1=10, field2='a'
      2nd record:  key=1, field1=11, field2='b'

      table1 has:

      key as numeric
      max1=Max(table2::field1)  /* Result as number */
      max2=Max(table2::field2)  /* Result as text */

      one record with key=1

      tables are related on 'key'

      Expected result

      max1 shows 11, max2 shows 'b'

      Actual result

      max1 shows 11, max2 shows nothing

      Exact text of any error message(s) that appear

      n/a

      Configuration information

      See also http://forums.filemaker.com/posts/2beb8259b4

      Workaround

      Don't try to use 'max' on text fields in related records!

      Screen_Shot_2012-08-04_at_14.04.11.png

        • 1. Re: 'Max' of text field doesn't work in related records

                

               barefootguru:

               Thank you for the post.

               According to the FileMaker Pro 12 help: "Aggregate functions perform statistical analysis on numbers." 

               The correct result will be pulled from a related text field, if the field contains numbers to evaluate. Using a rebuilt version of the example file provided in the screenshot, I added two additional records containing "15" and "20" into "field2" and as expected the Max function returns "20."

               See screenshot below.

               TSFalcon

               FileMaker, Inc.