Not [Not]

Return to Complete List of Functions

The Not function returns the logical opposite of a value by returning 1 for false values and 0 for true values. Parameters ------------------ Value         The value to use in the calculation. This is typically a field in a data series or a calculated value. Function Value ------------------------ This function returns the logical opposite of a given value. A condition is considered to be true if it has a non-zero value. Therefore, this function returns 0 for non-zero values and 1 when the given value is zero. If the value is null, a null is returned. Value    Not(Value) ------------------------------    -1             0     0             1     1             0