Skip to main content
Use this reference when a formula cell, database refresh, or modeled value does not behave as expected. Start with the visible label or symptom, then check the likely cause and fix.

​
Formula errors

​
Blank or unexpected values

​
Null vs. zero

Runway treats NULL and 0 differently. 0 is an explicit value. NULL means no value was returned. Features such as Most recent value can pull forward the last known non-null value, but they do not replace an explicit zero. For more examples, see Propagating sparse data.

​
Date-range misalignment

If a formula returns values in some months but not others, check the time range on the referenced driver or database field. A filter can exclude the month you are evaluating, and an integration-derived value may only exist in months where the source system returned data.

​
Actuals vs. forecast boundary

Actuals formulas apply through last close. Forecast formulas apply after last close. If a value changes when you move last close, check whether the actuals formula, forecast formula, or a hardcoded value is winning for that month.

​
Data refresh issues

​
Data source health

Each data source’s actions menu shows its refresh health. Healthy appears with the last-sync time. Disconnected or Log in to resume updates means Runway cannot refresh that source until the connection is restored.

​
Circular dependency blocks refresh

Some database refreshes can be blocked by a dependency cycle between databases. The alert title is Circular dependency blocks refresh, with summary These databases depend on one another, so Runway cannot refresh them automatically. The alert can show a LOOP section with the cycle path joined by →, plus DETAILS such as depends on, Through, and Fields. Break the cycle by changing the database formulas or configuration so one database no longer depends on another database that depends back on it.

​
Getting help

If you are still blocked, email support@cfo.ai with the error label, the driver or database name, the scenario you are in, and the formula or data source you were editing.

​
What’s next