Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Reverse Signs on Jet Function Results

Overview

Often times when building financial statements, the sign needs to be reversed in the report.

Use a negative sign before the GL(), NL(), of NF() functions to reverse the sign rather than multiplying by -1.

=-@GL("Balance",....)=-@NL("Sum",....)=-@NF($D4,....)

It creates a more efficient report to reverse a sign using Excel formatting rather than performing math on a Jet function.

Published:

Reverse Signs on Jet Function Results

Overview

Often times when building financial statements, the sign needs to be reversed in the report.

Use a negative sign before the GL(), NL(), of NF() functions to reverse the sign rather than multiplying by -1.

=-@GL("Balance",....)=-@NL("Sum",....)=-@NF($D4,....)

It creates a more efficient report to reverse a sign using Excel formatting rather than performing math on a Jet function.

For an optimal Community experience, Please view on Desktop