AnsweredAssumed Answered

Capturing summary data for a found set

Question asked by pasleeth on Aug 14, 2016
Latest reply on Aug 31, 2016 by pasleeth

Would anyone care to suggest what they think is the most efficient script for capturing summary statistical data (avg, max, min, std dev, count) of a found set in one FMP file and storing it in a related FMP file or table?


In this problem, every record in a found set shares the same value for the sort field (text), so that there's only one value for each of the five statistical summary fields listed above.  In other words, the script's objective is to store the five stats plus the sort field's value rather than export all the records from which those five stats are derived.


-- Andrew