Function arrays

A function array is the cluster of cells that contains the output from a single PI DataLink function. When you add a function to a worksheet, PI DataLink enters the function formula into the specified output cells. The function queries the Data Archive server or PI AF server and returns values in a function array. The size of the array depends on the function, the number of matching values available, the number of values requested, and the output requested.

The worksheet shows the returned values in the cells of a function array. However, these cells actually contain the function formula. You can view the function formula in the Excel formula bar when you select a cell.

• 1. Function formula in formula bar

• 2. Returned values in function array