Formula calculation

Calculates data using the specified formula and writes the results to the OBIS identifier used. The formula editor supports complex formulas, and data can originate from arbitrary metering points and OBIS measured variables. Status processing always uses the worst source status for the result. The calculation using this formula can be applied to all OBIS identifiers for all media. A user-defined completion trigger can be fired.

Where can I find this workflow?

Data Collection section => Metering point => Measured variables => Automation

Parameters

Calculation formula

Mathematical formula for the resulting data. The Formula Editor is available for creating the formula.

Time span

Defines how the time span of the action is determined.

  • Latest: The time elapsed between the last record and the time of execution.
  • Complete: The entire time span, starting from the timestamp of the first record.
  • Number of days: Full days in the past, counting from the time of execution.
  • Time range: Specify the start and end times precisely.

Last [Export / Calculation] date

The timestamp of the record processed by the last successful operation. Only active if “Latest” is selected as the time span.

Days

Number – Specifies the number of days for which the data request is carried out in the past. Starts at the time of execution.

Only active if “Number of days” is selected as the time span.

Time range

Start date / End date – Specifies the time range during which the action is to be carried out. Only active if “Time range” is selected as the time span.

Completion trigger

Trigger – Specifies the trigger that is executed once the workflow has finished.

Version

Date

Change

2.12

03/06/2022

FIX: Exception avoided when setting LastValidationDate if the status is invalid (2, 3 or 4) and the start timestamp is NULL

2.11

03/02/2022

Limited start date for the “newest” function

2.10

02/14/2021

FIX: Workflow terminated with an error if any source data table contains invalid data (status 2, 3 or 4)

2.9

03/04/2021

Corrected last calculation date

2.8

02/22/2021

Corrected update of the “newest” time range function

2.7

08/05/2020

Adjusted for performance indicators

2.6

08/22/2019

Corrected end date of the “newest” time range to UTC

2.5

07/23/2019

Corrected “newest” time range

2.4

07/17/2019

UPD: Added min and max functions

2.3

05/15/2019

Available in versions later than 4.7 Release 1 Build 12518; added the “newest” time range function and set it as the default Description updated

2.2

02/22/2018

FIX: Time range for TimeRangeChoice=FullRange read from the target MP-OBIS Used the time range of the source MP-OBIS from the formula

2.1

01/31/2018

UPD: Calculated time range for TimeRangeChoice=NumDays starts and ends on the hour rather than at the start of the day

2.0

05/12/2017

Multi-target workflows