The VALUE() function can be used in a variety of ways to get variable values.
Usage:
VALUE(variable, options, [max]) - see below for description.
VALUE('INC1_AE')
Get the latest value of the current device's variable named INC1_AE. Make sure to put variable names in single quotes if they contain spaces.
For device specific variables use a . to separate the device name:
VALUE('My Device.My Value')
Get the value of the variable 'My Value' in the device 'My Device'
You can also use VALUE('user_field1') to access the user defined field. These values are entered when you edit a device and can contain device specific static information. The list of special device-specific variables available are as follows:
| Variable | Description |
| device_key | MAC ADDRESS |
| remote_ip | IP Address of wattmon |
| last_access | last update timestamp |
| tz_offset | GMT Offset in seconds |
| geo_lat | Latitude of device |
| geo_lon | Longitude of device |
| user_field1 | User Defined field 1 |
The second parameter, [options] is a number and can be any of the following
| 0 | latest value (Default) |
| 5 | Period (in graph) - gets the value at the end of the selected segment in a graph |
| 7 | latest value for selected period |
The third optional parameter [max] allows you to specify a maximum value for the data point, and if the value is greater than this the result will be 0. This is to help in cases where incorrect data may come in from sensors are other devices.
Get the latest value of two watt hour counters and scaled them to kWh
(VALUE('delta0_wh',7)+VALUE('delta1_wh',7)) / 1000