This function examines a number series for those values that fall within a specified variance of a selected value.

This form has four parameters

• the column for analysis - a datalist of numbers
  
• the value for comparison
  
• the permitted variance
  
• the type of variance in relation to the value for comparison - more than only, more or less, less than only
  

The audit trail header is given in the form of a maximum/minimum range e.g. Col 'X' Range 1100 to 900

Remarks

This function operates on numeric (decimal) values only.

See also

List Analysis