3.5.1.1.22 Integrate

Description

Minimum Origin Version Required: 8.6 SR0

This function is used to integrate area under curve using . Missing values will be ignored. Note that the X values for the integration are row numbers. To calculate the area of a curve with arbitrary X coordinates, please use

Syntax

vector Integrate(vector vd)

Parameters

The vector for performing integration.

Return

Return the cumulative areas as dataset from the integration

Example

// using column
col(b) = Integrate(col(a));

// using dataset variable
dataset dsInput = {1, 2, 3, 4, 5};
dataset dsOutput = Integrate(dsInput);
dsOutput[2] = ;  // 1.5, get the second output value

// using range
range rInput = [Book1]Sheet1!col(1);
range rOutput = [Book1]Sheet1!col(2);
rOutput = Integrate(rInput);