Skip to main content

Why does my Total result in N/A?

Total line in a report incorrectly returns a N/A value or is just blank

Sandra McCarthy avatar
Written by Sandra McCarthy
Updated over 2 weeks ago

In the Account Tree that your report is using, it could be that a Calculation row is trying to include something that is no longer available.

Understanding "N/A" and Missing Totals in Reports

"N/A" values typically arise in Calxa when calculations cannot be completed due to missing or incomplete data. For example, if a formula references unavailable fields, it will display "N/A" instead of a numeric value.

When you create a New Account Tree in Calxa, it will automatically have Calculations rows included, for example, the Net Profit Row will include, by default this calculation:

If the Cost of Sales Section has been removed from the Account Tree, because it doesn't apply to your organisation, this calculation will return a N/A result as it is trying to subtract something that no longer exists.

To resolve this, remove the " - " operator, and " Cost of Sales Header " from this flow, APPLY CHANGES and re-run your report, this should now create the Net Profit line correctly.

If you still have problems with the calculation row, remove all the components and operators to clear the Formula and then click RUNNING TOTAL to recalculate.

Did this answer your question?