Skip to main content
Why does my Total result in N/A?

Total line in a report incorrectly returns a N/A value

Sandra McCarthy avatar
Written by Sandra McCarthy
Updated over a month 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.

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.

Did this answer your question?