SETNAVALUE

Purpose:

Replaces NaN values in a series with a specified value.

SETNAVALUE(series, value)

series	-	Optional. A series or table, defaults to the current Window.
value	-	A scalar value that replaces all NaN values in the specified series.

A series or table.

W1: {3.5, 5.0, 6.7, nan, 4.0, 8.0}

W2: setnavalue(W1, 0)

W2 sets all NaN values in W1 to 0.0 resulting in the series {3.5, 5.0, 6.7, 0.0, 4.0, 8.0}.

setnavalue(curr, 100)

sets all NaN values in the current Window to 100.

See NAFILL to replace NaN values based on neighboring data points.

See REMOVENA to delete NaN values.