...
This is how Column Calculation column will look like when you follow the above steps.
Image Added
Here's how it is shown when report is previewed/printed. The balances shown on Total column is the sum of Previous and Current columns.
Image Added
Expand |
---|
|
The Column Calculation column is intended to build formula from existing columns. The following rows can be selected to build a column calculation row. - Budget
- GL Amounts
- Debit
- Credit
- Debit Units
- Credit Units
- Units
- GL Trend
- another Column Calculation
Follow these steps to add a Column Calculation column. - A new row will be available in the grid section.
- In the Column Type field, select GL Amounts.
- In the Column Name field, enter the name you would like to call the column. The value entered in this field may show on your financial report, granted the Caption field for that column is set to Column Name. This is discussed more on How to Add Column Name Row.
- In the Caption field, select the type of caption you want for the column. This is discussed more on How to Add Column Name Row.
- In the Column Calculation field assign a formula. See How to Configure Formula for Column Calculation column.
- Leave the Segment Filter field blank.
- Leave the Budget Code field blank.
- Leave the Percentage field blank.
- In the Width field, set it to your desired column width. By default it is set to 160 pixels, which is approximately 1 1/4 inches.
- In the Alignment field, set how the value for the column be displayed.
- Select Center if you want it Centered
- Select Left if you want it Left Aligned
- Select Right if you want it Right aligned
- There is an ability to show or hide the column. Check the Hidden checkbox if you decide to hide the column. This is discussed more on How Hidden checkbox works when enabled.
- All other fields are not anymore necessary so you can leave those out.
This is how Column Calculation column will look like when you follow the above steps.
Image Modified
Here's how it is shown when report is previewed/printed. The balances shown on Total column is the sum of Previous and Current columns. Image Modified
|
Expand |
---|
|
The Column Calculation column is intended to build formula from existing columns. Budget, Calculation, Debit, Credit, Debit Units, Credit Units, Units, GL Trend, Ending Balance, Segment Filter and another Column Calculation columns can be used to build the formula.
Follow these steps to add a Column Calculation column. - A new row will be available in the grid section.
- In the Column Description field, enter the name you would like to call the column. The value entered in this field may show on your financial report, granted the caption for that column is set to Column Header. This is discussed more on How to Add Description Title Row.
- In the Caption field, select the type of caption you want for the column. This is discussed more on How to Add Description Title Row.
- In the Column Type field, select Column Calculation. The Column Calculation screen will automatically be opened where you can configure your formula. See How to Configure Formula for Column Calculation column to guide you on how to build your formula.
- Leave the Filter Type field blank.
- Leave the Segment Used field blank.
- Leave the Budget Code field blank.
- Leave the Start and End Date fields blank.
- In the Width field, set it to your desired column width. By default it is set to 160 pixels, which is approximately 1 1/4 inches.
- In the Alignment field, set how the value for the column be displayed.
- Select Center if you want it Centered
- Select Left if you want it Left Aligned
- Select Right if you want it Right aligned
- In the Format field, assign how the numbers be shown in the column. Will it have decimals, money sign or in percentage format.
- Leave Hidden checkbox unchecked. See How Hidden checkbox works when enabled.
This is how Column Calculation column will look like when you follow the above steps.
![](/download/attachments/4489241/image2015-4-13%2014%3A18%3A20.png?version=1&modificationDate=1428905914490&api=v2&effects=border-simple,shadow-kn)
Here's how it is shown when report is previewed/printed. The balances shown on Total column is the sum of Previous and Current columns.
![](/download/attachments/4489241/image2015-4-13%2014%3A19%3A47.png?version=1&modificationDate=1428906000897&api=v2&effects=border-simple,shadow-kn) |
...