Type: Function
Function: HAS_ANY_VALUE
Syntax: HAS_ANY_VALUE(value)
Description: Returns true for every record, whatever the value, including no value.
It does not filter anything. To keep the records which have a value, use IS_NOT_NULL.
It is the same condition as the has any value filter of the insight designer (see Using filters), which keeps a filter in place without applying it.
Sample usage:
HAS_ANY_VALUE(due_on)returnstruefor every record.