Extract the most recent observation (by year) from a series, preferring published actuals over forecasts when both are present for the same latest year.
Returns null when the series contains only null values or is empty.
null
Series observations (in any order).
Most recent observation with a non-null value, or null.
Extract the most recent observation (by year) from a series, preferring published actuals over forecasts when both are present for the same latest year.
Returns
nullwhen the series contains only null values or is empty.