Open topic with navigation

Sum Nodes in Policy Designer

A Sum node is a Calculation node that you can use in a policy model to calculate the total value of data in a specified column of a collection.

The input for a Sum node must be a collectionA set of results from a Query node or a set of readings associated with input nodes such as Measurement Location, Health Indicator, or OPC Tag. containing numeric or time span values. The output of a Sum node, Value, contains the result of the calculation for the specified column.

Node PropertiesClosed

The Properties window for a Sum node contains the items that are described in the following table.

Item

Description

Notes

Collection section

Specifies the collection that contains the values for which you want to calculate the total value.

 You can select to specify the output of a predecessor node in this section.

Note: If the input specified for a Sum node is an empty collection, the resulting answer from the Sum node is automatically zero (0).

Collection Column section

Specifies the column that contains that values for which you want to calculate the total value.

This list contains the columns that are available in the selected collection.

The column that you select must contain numeric or time span values.
ExampleClosed

The following example illustrates how you can use a Sum node in a policy model to determine the total value of the Measurement Location readings that were taken within the last week. Consider the following nodes and connections.

In this example, the Collection Filter node is used to filter the readings associated with the Measurement Location node to only the readings that were recorded within the last week. The Sum node is then used to calculate the total value of these readings. The following image shows what the Properties window looks like for the Sum node.

Related Information

Copyright © 2018 General Electric Company. All rights reserved.