Cumulative

Cumulative of values within time range.

Syntax

 Cumulative("signal name" in "unit")

The Cumulative("signal name" in "unit") function returns the cumulative sum of the given signal within a given scope. To take into account prior cumulatives before the start of the specified scope, please see HistoryCumulative .

Example

In the following P# script example, the Cumulative() function sums the signal data within the scope defined in the script. Note that the values prior to the January 2, 2007 start of the given scope are ignored by the Cumulative() function. To take into account these prior values, see HistoryCumulative.

 Cumulative("produced water per time increment" in "STB")

As you see in the following table the Cumulative function which produces following output based on the 'original signal' as input:

// This P# script illustrates how to use the Cumulative() function
Context "Example Context"
    Entity Set "Example Well"
    Scope "Example Scope"
End Context

Entity Set "Example Well"
    "Well A"
End Set

Scope "Example Scope"
    Between #1/2/2007#
    And #1/9/2007#
    Step Daily
End Scope

Table "Cumulative Example"
    // This column is not necessary, but is included here for clarity
    Column "Produced Oil" in "STB"
        "produced oil per time increment" in "STB"
    End Column
    // This column is where the results are computed
    Column "Cumulative Oil" in "STB"
        Cumulative("produced oil per time increment" in "STB")
    End Column
End Table