Description
The LATEST function retrieves the value of a specified attribute from the most recently created record linked.
Usage
The function is used to extract the latest value from a given attribute.
Syntax:LATEST(attribute)
Examples
-
Retrieve Latest Value and Apply Conditional Logic:
IF(LATEST(#[Actions].[Number]) > 1, true, false)Retrieves the most recent value from the Number field in the Actions table from the most recently created record. If the value is greater than 1, it returns TRUE; otherwise, it returns FALSE.
-
Filter and Retrieve Latest Value:
LATEST(FILTER(#[Risk Assessment].[Assessment Score], #[Risk Assessment].[State] = "Complete"))Retrieves the most recent Assessment Score value from the Risk Assessment table of the most recently created record, where the State is "Complete."
Inputs
| Argument | Data Type | Description |
|---|---|---|
| attribute | Any | The attribute from which to get the latest value. |
Returns
Type: Any
- Returns the most recent value of the specified attribute from the most recently created record.