This function is very similar to the standard numeric operators of less than or more than, however we use the terms bigger and smaller to show that the function can (if required) ignore the sign of a number.

This form has four parameters

• the data column for analysis
  
• the type of analysis - bigger than, smaller than
  
• the 'significant number' or the number for comparison
  
• the sign of the numbers that are deemed to meet the criteria
  

The audit trail header takes the format (e.g. Col 'A' bigger than 5000 (+) or Col 'A' smaller than 5000 (-)). The sign of the numbers deemed to meet the criterion is always shown in parentheses.

Remarks

This function operates on numeric (decimal) values only.

See also

List Analysis