Sum

Sum of values within a time range.

Syntax

Sum(expression)
  • expression: signal expression
  • Prefix
    • TIME for calculation of the Sum function for all time steps for one entity (default setting, can also be neglected)
      • Time Sum("x" in "unit") function returns the sum of values for all the elements within the given time range.
    • ENTITY calculation of the Sum function for all entities at one time step (has to be placed in front of function if needed)    
      •  Entity Sum("x" in "unit") function returns the sum of values for all the entities for a given time step.

Example

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

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

Date/Time

Original Signal

Sum

01.02.2007 00:00

8

115

01.03.2007 00:00

0

115

01.04.2007 00:00

15

115

01.05.2007 00:00

22

115

01.06.2007 00:00

24

115

01.07.2007 00:00

13

115

01.08.2007 00:00

27

115

01.09.2007 00:00

6

115

Entity Sum("produced water per time increment" in "STB")

As seen in the following table the Entity Sum function produces following output based on the 'original signal1' and 'original signal2' as input:

Date/Time

Original Signal1

Original Signal2

Entity Max for signal1

Entity Max for signal 2

01.02.2007 00:00

8

#NULL!

8

8

01.03.2007 00:00

0

#NULL!

0

0

01.04.2007 00:00

15

19

34

34

01.05.2007 00:00

22

12

34

34

01.06.2007 00:00

24

34

58

58

01.07.2007 00:00

13

19

32

32

01.08.2007 00:00

27

15

42

42

01.09.2007 00:00

6

19

25

25