Several mathematical functions described in the Custom Token Formula Reference, such as Mean, StdDev, Minimum, Maximum, and Range, work on arrays. The arrays can contain an unlimited number of elements enclosed in square brackets and separated by commas. These elements can be constants or tokens.
For example:
•Using the formula =Minimum([54,36,75,89,39]) returns 36 when the custom token is inserted in a text box.
•The formula in Figure 19.50 will return the mean of the Y Median values of the Upper Left quadrant across four dot plots.
Figure 19.50 Using Tokens in an Array Formula