AnsweredAssumed Answered

Max() returns value in found set, of currently shown record, not maximum value in set

Question asked by shi_guy on May 25, 2012
Latest reply on May 25, 2012 by philmodjunk

Summary

Max() returns value in found set, of currently shown record, not maximum value in set

Product

FileMaker Pro

Version

12

Operating system version

Windows 7

Description of the issue

I am doing a Max() calculation on a set of data, and Max() only returns the value that is currently displayed, NOT the Maximum value in the data set. If you scroll through the records while viewing the Max() calculation in the data viewer, it changes as each record is displayed. Data is 'number'

Steps to reproduce the problem

Look at Data Viewer and Max(number field).  This does not show max value, as you scroll through records, this value for Max changes... it should not.

Expected result

Maximum value in found set

Actual result

Value of selected record

Workaround

None found, had to write a script with more steps to produce the desired result.  In a large database, this could be a speed issue.

Outcomes