Chk clmn f. +/- sign

Definition

If a +/- sign check is active from the sets and should only be applied to a certain column, you must enter the number of the column from which the amount for the sign check is to be used.

General information on the +/- sign check

In Report Writer, you often need to display a row only when the value of a column is positive or negative. The number of this column is defined in the layout parameters.

Using the +/- sign indicator, a field value or set can be selected so that the respective row is only displayed if the relevant column value is positive or negative.

Possible entries:

' '

' '(Default setting) The row is always displayed.

'+'

'+'The row is displayed only if the value in the column is positive (or 0).

'-'

'-'The row is displayed only if the value in the column is negative.

You define whether the +/- sign check is active and which column is used for the +/- sign check in the layout parameters for the +/- sign indicator ("Row totals" screen, "+/- sign indicator" in the report definition.

Example

Account set with balance sheet accounts:

The bank accounts appear either on the assets or the liabilities side of the balance sheet, depending on their +/- sign. A simple example is shown below:

 
               ------------------------ 
               |Balance sheet accounts| 
               ------------------------ 
            --------------|--------------- 
   ---------|---------          ---------|--------- 
   |     Assets      |          |   Liabilities   | 
   |-----------------|          |-----------------| 
     |             |              |             | 
 Bank acct 1    Bank acct 2   Bank acct 1    Bank acct 2 
  (with +)       (with +)      (with -)       (with -)

If bank account 1 contains the amount +1000.00 and bank account 2 contains the amount -1000.00 in the database, the resulting list will be as follows:

 
----------------------------------- 
|   Bank acct 1    |    +1000.00  | 
|*  Assets         |    +1000.00  | 
----------------------------------- 
|   Bank acct 2    |    -1000.00  | 
|*  Liabilities    |    -1000.00  | 
----------------------------------- 
|** Total          |        0.00  | 
-----------------------------------

Add-on

The +/- sign check can be executed for several columns. In the case, the +/- sign check is used separately on each non-formula column. If we enhance the above example, so that bank account 1 contains the amount -500.00 in the previous year and bank account 2 has +500.00 in the previous year, the list appears as follows:

 
                    |     Year    |  Prev. year | 
------------------------------------------------- 
|   Bank acct 1     |    +1000.00 |             | 
|   Bank acct 2     |             |     +500.00 | 
|*  Assets          |    +1000.00 |     +500.00 | 
------------------------------------------------- 
|   Bank acct 1     |             |     -500.00 | 
|   Bank acct 2     |    -1000.00 |             | 
|*  Liabilities     |    -1000.00 |     -500.00 | 
------------------------------------------------- 
|** Total           |        0.00 |        0.00 | 
-------------------------------------------------