Max() returns value in found set, of currently shown record, not maximum value in set
Operating system version
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.
Maximum value in found set
Value of selected record
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.