AnsweredAssumed Answered

Summarizing statistics on a found set

Question asked by alfredsenn on Sep 22, 2016
Latest reply on Sep 23, 2016 by David Moyer

For a given found set of records, I would like to extract for some variables summary statistics such as, count, min, max, average and standard deviation. I would like to do this through a script without creating new variables.

The statistics functions (count, min, max, ...) used in a script will return the value related to the entire table and not for the found set. By creating a self-joined relationship between the entire table and the recods that are in the found set, the statistics are evaluated correctly. Setting up manually a variable in my table equal to one for the records that are in the found set is time-consuming. Is there a GET function that would identify the records in the found set