Formula errors

These are some errors you might encounter when using formulas, and their possible causes:

#DIV/0!

The formula attempts to divide by zero.

#N/A

The parameters of the formula are correctly specified but the result does not exist. This error is also displayed if the value in the database is NULL.

Note: Rarely, #REF might be displayed in place of #N/A. This can occur if the precise location of the error cannot be determined.

#NAME?

Indicates, for example, that you have misspelled the name of the formula. For example =ssum instead of =sum. Or it can indicate that a string parameter in the formula is not enclosed in double quotes.

#NULLPTR!

#NULLPTR! is displayed if, for example, you specify intersecting ranges, but the ranges do not intersect. For example this formula specifies an intersection between rows E and F: =E7:F7 E8:F8 but there is no point at which two rows intersect

#NUM!

The formula returns a value which is too large. Or, an invalid number is specified as an argument of the formula.

#OBJECT!

An object referenced by the formula does not exist. For example, a formula references a list view object which is then deleted.

#REF

A data connection or cube referenced by the formula does not exist or is not currently connected. Or, a cell referenced by the formula does not exist. For example the formula is in a value cell of a hyperblock and references the key index cell, and the hyperblock is then deleted.

Note: Rarely, #NA might be displayed in place of #REF. This can occur if the precise location of the error cannot be determined.

#VALUE

The formula uses text where numbers are required. For example, the formula =sum("I",2,3) generates #VALUE.

The error might also be displayed in View mode in Application Studio, but not in Design mode. This can happen if, for example, the formula is outside a hyperblock but references a cell which is occupied by a hyperblock.