Usage
not (x)
Reverses the True or False value of x.
Examples
not (A>B and B>C)
If A=5, B = 4, C = 3, the expression (A>B and B>C) is TRUE. Both conditions tied together by the Boolean operator And are TRUE; thus, the entire statement has a value of TRUE. The Not operator changes the value of the expression to FALSE.
not (A>B and B>C)
If A=3, B = 4, C = 3, the expression (A>B and B>C) is FALSE. One of the two conditions tied together by the Boolean operator And is FALSE; thus, the entire statement has a value of FALSE. The Not operator changes the value of the expression to TRUE.
not ({file.ONHAND} - {file.ORDER} > 0)
Returns TRUE if {file.ONHAND} = 10 and {file.ORDER} = 11.
not ({file.ONHAND} - {file.ORDER} > 0)
Returns FALSE if {file.ONHAND} = 10 and {file.ORDER} = 9.