Last

Last value of all input values.

Syntax

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

Example

Time Last("produced water per time increment" in "STB")

alternative version

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

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

Date/Time

Original Signal

Time Last

01.02.2007 00:00

8

6

01.03.2007 00:00

0

6

01.04.2007 00:00

15

6

01.05.2007 00:00

22

6

01.06.2007 00:00

24

6

01.07.2007 00:00

13

6

01.08.2007 00:00

27

6

01.09.2007 00:00

6

8

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

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

Date/Time

Original Signal1

Original Signal2

Entity Last for signal1

Entity Last 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

19

19

01.05.2007 00:00

22

12

12

12

01.06.2007 00:00

24

34

34

34

01.07.2007 00:00

13

19

19

19

01.08.2007 00:00

27

15

15

15

01.09.2007 00:00

6

19

19

19