RefTablesIntersection()

Returns intersection value of 2 specified last reference tables for current entity.

Supported intersection return value (case-insensitive, with or without spaces between words):

1. Max Key

2. Min Key

3. Max Value

4. Min Value

Syntax

double RefTablesIntersection(
     refTable1 as a string, 
     refTable2 as a string, 
     intersection as a string, 
     UnitName as a string, 
     UnitName as a string, 
     timeStampOption as a string
)

Example

RefTablesIntersection("reference table 1", "reference table 2", "Max Key", 
     "Pa", "m3", "Current")

Example

RefTablesIntersection("reference table 1", "reference table 2", 
    "Max Key", "RefValue", "Pa", "m3", "None")

RefTablesIntersection(
     refTable1 as a string, 
     refTable2 as a string, 
     intersection as a string, 
     ColumnName1 as a string, 
     ColumnName2 as a string, 
     UnitName as a string, 
     UnitName as a string, 
     timeStampOption as a string)

RefTablesIntersection("reference table 1", "reference table 2", "Max Key", 
     "RefValue1", "RefValue2", "Pa", "m3", "Last")