1. Home
  2. /
  3. User Guides
  4. /
  5. Report Writer
  6. /
  7. Report handling
  8. /
  9. Working with columns
  10. /
  11. Define a calculated column...

Define a calculated column with percentage code and selected period

Related topics

The following describes how to create a calculated column, AVR VAT (Average VAT amount), where the formula contains a percentage code and the code for selected period. You are also able to enter a comment in the formula.

The columns you will need to define are the following:

For your information, the AVR VAT column looks like this on a printout:

Printout example

The AVR VAT column is calculated as:

(SALES VALUE Feb + SALES VALUE Jan) / 2 * 0,25

SALES VALUE (February)

  1. Select the Work with reports menu item.
  2. On the main panel, select the applicable report and click Columns.
  3. You access Work with report columns. Click Add.
  4. On the detail panel, complete the fields as follows:
    5. Column number
    Enter 10.
    Column heading 1
    Enter “SALES VALUE”.
    Column heading 2
    Enter “February”.
    Column type
    Enter 1.
    Balance type
    Enter SNET.
    Year
    Here, leave the fields blank.
    Period
    Enter 2 in both fields (February).
    Relative year
    Set both fields to YES.
    Relative period
    Set both fields to NO.

    Click OK to update the column. Continue by defining the next column.

    SALES VALUE%

  5. On the Work with report columns panel, click Add.
  6. On the detail panel, complete the fields as described below:
    7. Column number
    Enter 20.
    Column heading 1
    Enter “SALES VALUE”.
    Column heading 2
    Enter “January”.
    Column type
    Enter 1.
    Balance type
    Enter SNET.
    Edit code
    Enter 22.
    Year
    Here, leave the fields blank.
    Period
    Enter 1 in both fields (January).
    Relative year
    Set both fields to YES.
    Relative period
    Set both fields to NO.

    Click OK to update the column. Continue by defining the next column.

    AVR VAT

  7. On the Work with report columns panel, click Add.
  8. On the detail panel, complete the fields as described below:
    9. Column number
    Enter 30.
    Column heading 1
    Enter “AVR VAT” (average VAT amount).
    Column type
    Enter 92, which means “Calculated column”.
    Edit code
    Enter 1.
    Calculation
    The formula should look like this:

    (C10+C20) / SLP * %25
    Description of the variables:
    Variable Description
    C10 Value in column 10.
    C20 Value in column 20.
    SLP The period you select when the report is printed. Here, period 2 was selected.
    %25 The percentage code 25 in the Percentage code table. Here, the percentage code 25 is defined with a percentage of 25 %.

    If you want to enter a comment in a formula you have to enter an exclamation mark before the text. Like this:

    (C10+C20) / SLP * %25 !This is a comment.

    Click OK to update the column and exit the routine.

Related topics