(KPIArray) Function Formula
- Last UpdatedNov 03, 2025
- 1 minute read
The KPIArray function uses the following formula. You must use the following form for the input functions and then press Ctrl + Shift + Enter keys.
Formula
=KPIARRAY(<KPINAME >,< PropertyName >,< Unit >,< StartDateTime >,< EndDateTime >,< InnerObject >,< OutputDirection >,< DisplayDates > ,< Connectionname >)
Example
=KPIArray ( "LD_NCC_KPI1", " ExpValue ", " MassDefUnit ", "6/1/2008 11:59:00 PM", "6/24/2008 11:59:00 PM", "*", "Vertical", TRUE, "Petro")
Parameters
|
Parameter |
Description |
|
KPIName |
The name of the KPI. |
|
PropertyName |
The name of the property which contains only KPI value. |
|
StartDateTime |
Starting date/time. (Greater than or Equal to) |
|
EndDateTime |
Ending date/time. (Less than) |
|
OutputDirection |
The direction of the result range. You can only use Vertical or Horizontal. |
|
DisplayDates |
If the result includes starting date/time and ending date/time. |
|
Connection Name (Optional parameter) |
Name of the connection which contains database details. If the connection name is not specified, then the default database connection is used. |