How Analytics displays invalid data in views

Analytics uses the following distinct character sequences to highlight invalid data in views:

• ###### – A series of number signs is used to identify numeric values where the width of the column is less than number of digits to be displayed.

  These values are highlighted as invalid so that an incorrect value is not displayed on screen (e.g., 100 being displayed instead of 10100), and because the value will cause reports that include the value to be misaligned. The full value is printed in the report which will result in the adjacent columns being misaligned.

  You can correct this problem by increasing the Width property of the column to a value large enough to display all of the digits.

• ### ERR ### – This character sequence is displayed when the numeric value in a column is invalid or undefined.

  Numeric overflow is caused by operations such as division by zero or division by a very small number. You need to correct the value or remove the column from the view before you can generate a report from the view.

If the numeric value is larger than the column width, and the value is invalid or undefined, the number sign character sequence (######) will be displayed until the width of the column is increased, and then the ### ERR ### character sequence will be displayed.