Skip to main content
All CollectionsFAQsKPIs
FAQ: Why is my KPI calculating a null result?
FAQ: Why is my KPI calculating a null result?

When default or custom KPIs do not calculate or show the ' - ' symbol

Updated over a month ago

When a KPI cannot be calculated, the ‘ - ’ symbol will appear as a placeholder result.

Default KPIs

Balance Sheet ratios

If one of the variables is negative, the ratio will not yield a result.

Example: Current Ratio = Current Assets / Current Liabilities. If Total Current Liabilities is negative, the ratio will not calculate, and will yield a null result.

To find out which variables are used in calculating a default KPI, visit the KPI Glossary.

Custom KPIs

Non-Financial KPIs

If a Non-Financial KPI yields a null result, non-financial data for the viewed period may not have been imported into Fathom. To update non-financial data, go to ‘Update Data’ in the company’s Settings.

📝 Note: For KPIs in consolidated groups, the Non-Financial data must be imported and up-to-date in each of the underlying companies before updating the consolidation.

Formula KPIs

If a Formula KPI is returning a null result, the account or data it is referencing may not be up to date in Fathom. To view a custom KPI’s formula, you’ll need to go to ‘KPIs’ in the company’s Settings and edit the KPI.

A null result will be returned if an account referenced in a Formula KPI is not in the company’s Chart of Accounts. This might happen if an account has been removed from the Chart of Accounts in the source accounting system. To verify that an account is included in the company’s Chart of Accounts, go to ‘Chart of Accounts’ in the company’s Settings.

Similarly, if a formula KPI references a Non-Financial KPI in its formula and data for the Non-Financial KPI has not been imported for the period, the Formula KPI and the Non-Financial KPI will yield a null result.


Learn more

Did this answer your question?