Versions Compared

Key

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

The Row Calculation row is intended to build formula from existing rows. The following rows can be selected to build a row calculation row.

  • Cash Flow Activity row
  • Filter Accounts row
  • Percentage row
  • and another Row Calculation row 

Follow these steps to add a Row Calculation row.

  1. From the Row Type section select Row Calculation and drag it to the grid area, in the position you want that row be added.
  2. Enter a value in the Row Name field. This value should be as descriptive as possible so it would be easy to read what row is that for. 
  3. In the Row Calculation field assign a formula. See How to Configure formula for Row Calculation row
  4. All other fields are not anymore necessary so you can leave those out.

This is how Row Calculation row will look like when you follow the above steps.
Image Added

This is how it will be shown when you print your financial report.
Image Added

You can enhance this row by setting its Font Properties and Row Height. See How to Configure Row Font Properties and Row Height topic to guide you on how to do this.


Expand
title18.3

The Row Calculation row is intended to build formula from existing rows. The following rows can be selected to build a row calculation row.

  • Cash Flow Activity row
  • Filter Accounts row
  • Percentage row
  • and another Row Calculation row 

Follow these steps to add a Row Calculation row.

  1. From the Row Type section select Row Calculation and drag it to the grid area, in the position you want that row be added.
  2. Enter a value in the Row Name field. This value should be as descriptive as possible so it would be easy to read what row is that for. 
  3. In the Row Calculation field assign a formula. See How to Configure formula for Row Calculation row
  4. All other fields are not anymore necessary so you can leave those out.

This is how Row Calculation row will look like when you follow the above steps.
Image Added

This is how it will be shown when you print your financial report.
Image Added

You can enhance this row by setting its Font Properties and Row Height. See How to Configure Row Font Properties and Row Height topic to guide you on how to do this.

Expand
title18.1

The Row Calculation row is intended to build formula from existing rows. The following rows can be selected to build a row calculation row.

  • Cash Flow Activity row
  • Filter Accounts row
  • Percentage row
  • and another Row Calculation row 

Follow these steps to add a Row Calculation row.

  1. From the Row Type section select Row Calculation and drag it to the grid area, in the position you want that row be added.
  2. Enter a value in the Row Name field. This value should be as descriptive as possible so it would be easy to read what row is that for. 
  3. In the Row Calculation field assign a formula. See How to Configure formula for Row Calculation row
  4. All other fields are not anymore necessary so you can leave those out.

This is how Row Calculation row will look like when you follow the above steps.
Image Added

This is how it will be shown when you print your financial report.
Image Added

You can enhance this row by setting its Font Properties and Row Height. See How to Configure Row Font Properties and Row Height topic to guide you on how to do this.

Expand
title16.1

The Row Calculation row is intended to build formula from existing rows. The following rows can be selected to build a row calculation row.

  • Cash Flow Activity row
  • Filter Accounts row
  • Percentage row
  • and another Row Calculation row 

Follow these steps to add a Row Calculation row.

  1. From the Row Type section select Row Calculation and drag it to the grid area, in the position you want that row be added.
  2. Enter a value in the Row Name field. This value should be as descriptive as possible so it would be easy to read what row is that for. 
  3. In the Row Calculation field assign a formula. See How to Configure formula for Row Calculation row
  4. All other fields are not anymore necessary so you can leave those out.

This is how Row Calculation row will look like when you follow the above steps.
Image Added

This is how it will be shown when you print your financial report.
Image Added

You can enhance this row by setting its Font Properties and Row Height. See How to Configure Row Font Properties and Row Height topic to guide you on how to do this.

Expand
title15.3 and below

The Total Calculation row is intended to build formula from existing rows. Calculation, Hidden, Cash Flow Activity and another Total Calculation rows can be used to build the formula. 

Follow these steps to add a Total Calculation row.

  1. A new row will be available in the grid section.
  2. Enter a value in the Description field. This value should be as descriptive as possible so it would be easy to read what row is that for. 
  3. In the Row Type field, select Total Calculation.
  4. The Row Calculation screen will automatically be opened. Configure formula for this row. See How to Configure formula for Percentage row to guide you on how to build/configure your formula.
  5. Leave out Balance Side field. 
  6. Leave out Filter Accounts field.

This is how Total Calculation row will look like when you follow the above steps.
Image Added
This is how it will be shown when you print your financial report. Highlighted row in yellow is the Total Calculation row where it uses the formula configured to get the amount it is showing and the rows boxed in red are rows that compose the formula.
Image Added
You can enhance this row by setting its Font Properties and Row Height. See How to Configure Row Font Properties and Row Height topic to guide you on how to do this.

Expand
title14.4

The Total Calculation row is intended to build formula from existing rows. Calculation, Hidden, Cash Flow Activity and another Total Calculation rows can be used to build the formula. 

Follow these steps to add a Total Calculation row.

...

  1. A new row

...

  1. will be available in the grid section.
  2. Enter a value in the Description field. This value should be as descriptive as possible so it would be easy to read what row is that for. 
  3. In the Row Type field, select Total Calculation.
  4. Place your cursor in

...

  1. the Related Rows field

...

  1.  and you will see an ellipsis button. Click that button and Row Calculation screen will open. See How to Configure formula for

...

  1. Percentage row to guide you on how to build your formula.
  2. Leave out Balance Side field. 
  3. Leave out Filter Accounts field.

This is how Total Calculation row will look like when you follow the above steps.

...

Image Added
This is how it will be shown when you print your financial report. The balances shown per column is the sum of Row 12 - Equity - exclusive of RE, Row 13 -

...

 Retained Earnings and Row 14 -

...

 Current Year Earnings.

...

Image Added
You can enhance this row by setting

...

its Font Properties

...

 and Row Height. See How to Configure Row

...

Font Properties and Row Height topic to guide you on how to do this.