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.

In Office Plus, #NA is displayed in respect of elements and dimensions which do not contain values. In Application Studio these are represented by 0.

In both Office Plus and Application Studio you can specify a different code to represent the #N/A error. In Office Plus use the Captions and Error Values tab of the Options dialog. For Application Studio use Representation of Empty Cells in the settings of the report catalog in Repository Administration.

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. For example, in Office Plus, the formula =sum(I,2,3) generates #NAME? In Application Studio the same formula cannot be specified.

In Office Plus, the #NAME? error also happens if you specify an invalid range of values. For example, here, the comma separator is missing between B5 and C1:

=SUM(A1:A5,B1:B5C1:C5,D1:D5).

In Application Studio the same formula generates the #nullptr! error.

#NULL!

In Office Plus, #NULL! 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.

In Application Studio the same formula displays #nullptr!

#NULLPTR!

See #NULL!

#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, in Application Studio, the formula references a list view object which is then deleted.

#REF

A database alias 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, in Application Studio, 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.

Note: In Office Plus you can specify a different code to represent the #VALUE error.