Standing for not a number, the NaN
error appears when you attempt to divide zero by zero. To fix the error, the most simple approach is to run a valid formula that results in a definable number (e.g. anything but 0 / 0). However, you may want to conditionally run a different calculation for instances when two fields both have a zero value.
For example, if you're tracking progress towards a goal. You would use the formula {Actual} / {Goal}
to display progress towards that goal as a percent. However, because formulas apply to every record in a table, NaN
shows for any records where there are zero values in both fields.
<See image 1 as an example>
A circular reference error occurs when one field is trying to calculate off a second field, while the second field is trying to calculate off the first. It doesn't know where to start and creates a loop that can't be completed.
In the example below, the {Name} field is referencing itself, causing a circular reference error.
<See image 1 as an example>
To uncover the circular reference, take a closer look at what other fields your formula is referencing -- it's likely referencing another formula field, which in turn is referencing (perhaps indirectly, through yet another formula field!) the original formula field (the one throwing the "circular reference" error when trying to save the formula.
The #ERROR or invalid formula error warnings point to a number of potential problems (a catch-all for any errors other than those listed in the following sections). We don't currently surface any more context on the source of the error, so you'll need to put on your best troubleshooting hat to find the source of the issue.
Some of the typical mistakes you should look for when encountering #ERROR are:
The #ERROR or invalid formula error warnings point to a number of potential problems (a catch-all for any errors other than those listed in the following sections). We don't currently surface any more context on the source of the error, so you'll need to put on your best troubleshooting hat to find the source of the issue.
Some of the typical mistakes you should look for when encountering #ERROR are:
The infinity error occurs when you divide a number by zero (which equals infinity). Since there isn't a way to represent this as a number, you'll need to adjust your formula to divide by a number other than zero.
As an example, an engineering team is working on tracking a quota of bugs addressed by each teammate. In the screenshot below, you'll see an infinity error when dividing {Completed Issues}
by {Bug Quota}
.
<See image 1 as an example>