Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Solution: Introduce a user-defined parameter field in the report and create a new expression to achieve this.

Open the "Income and Expense (Operational)" report from Accounting > Reports of Accounting.

Image Added

Go to More action > Change report variant > Add a new expression field

Image Added

Go to user fields > click on Add option > New expression field

Image Added

In the new dialog box, add the desired title. Then, in the detailed records expressions section, input the formula:

[Income Amount Turnover]−[Expense Amount Turnover]

Image Added

Click on OK to save the formula.

Image Added

Go to the Fields tab and add the user-defined field to the Selected Fields section, as shown below.

Image Added

Double-click on the Income/Expense item from the upper pane. Then, add the user-defined field to the right side of the dialog box i.e. in Edit Grouping Field.

Image Added

The document will display the Income and Expenses in a single column, as illustrated below.

Image Added

Thanks for being a Firstbit customer!                                        #Income and Expense (Operational) # User-defined fields in the report