Overview of common errors and their explanations.
#DIV/0
#DIV/0
error occurs when an attempt is made to divide a value by zero (0). Division by zero is mathematically undefined and therefore not permitted.#DIV/0
error, use the IGNORE_DIV_ZERO()
function. Learn more here.#NO_FRAC
#NO_FRAC
error arises when a row is aggregated using a weighted average (W.AVG), but the formula for the row contains something other than a simple fraction (a/b
)#ERR
#ERR
error typically indicates an issue with invalid syntax or an incomplete formula. For instance, entering 5+
in the formula editor results in #ERR
because the plus sign (+) is incomplete and requires an additional value.#INF_LOOP
#INF_LOOP
error is triggered when an infinite loop is detected, typically caused by a recursive back-reference. This often happens when a calculation references itself. Since calculations are consistent across all periods (the same formula applies in each period), self-referencing leads to an infinite loop, which is not supported.#CIRCULAR
#CIRCULAR
error is caused by defining a circular dependency between cells. For example, this might occur when two cells, a
and b
, reference each other, or when a series of cells collectively create a circular dependency.#FUTURE_REF
#FUTURE_REF
error happens when references are made to future periods. Francis only supports references to cells in the current period or earlier.0
, a #FUTURE_REF
error will always be thrown. For example, Revenue[1]
is invalid because it refers to the Revenue
row one month into the future. However, Revenue[0]
and Revenue[-1]
are valid references, as they point to the current and prior months, respectively.#INVALID_REF
#INVALID_REF
error typically occurs when a reference is made to a cell that does not exist. This is often the result of referencing a row that was deleted.#BAD_ARG
#BAD_ARG
error occurs when an argument provided to a function does not match the expected input type. This may include using a boolean value where a number is expected, or vice versa.#BAD_ARG
error, carefully review the Docs on functions to ensure you are using the correct input types while building your model.#BAD_TYPE
#BAD_TYPE
error occurs when an argument provided to a function is of an incompatible type. For example, supplying a number or boolean when the function expects a range.#REF_ERR
#REF_ERR
error is returned when a cell references another cell that contains an error. Essentially, if your formula points to a cell with any of the errors mentioned above, Francis will return a #REF_ERR
.