LastNonEmpty Function

image_pdfimage_print

With this function, empty column values are replaced by the last column value of preceding rows that are not empty, which means that the value from the last time that was not empty is repeated.

Parameters

EmptyValue

The value that is considered as an empty value. By default, empty spaces consist of space, multiple spaces, blank, or null values. For example, value “0” can be replaced with last none “0” value. In most cases, this parameter can be omitted.

Default

If all preceding rows have an empty value, the default value is returned.
image_pdfimage_print
Was this post helpful?
NoYes (-1 rating, 1 votes)
Loading...