Column and Row Specifications

« Axis Specifications | Loop Specifications »

This manual is in pilot operation.

Column and row specifications are used to specify various conditions for the display of columns or rows. The items that can be specified in both column and row specifications are the same and listed below.

Table of Contents

Column and Row Specifications
Drill-down

Label and Name

Item	Setting
Label	The label used to refer to this column/row in formulas.
Name	The name given to describe the column/row. It is a multilingual string and does not affect the display in reports or screens.

Item

Setting

Label

The label used to refer to this column/row in formulas.

Name

The name given to describe the column/row. It is a multilingual string and does not affect the display in reports or screens.

Cell Value Display and Editing Rules

Item Setting

Item	Setting
Data Source	The default data source for each column/row. The actual data source applied is determined by arbitration for each combination of column and row definitions.
Formula	The text expression used to calculate the value displayed in the column/row. The actual formula applied is determined by arbitration for each combination of column and row definitions. The result of the formula may be a string, not necessarily a number.
Reflect calculated value to ledger	Specifies whether you want the value calculated by the formula^[1] to be written to the ledger (if not specified, the calculated value is displayed only and not written to the ledger). For writing, each target cell must have a data source (ledger and dimension member) specified completely. Whether this item is actually enabled is determined according to the arbitration of the formula. If the data type of the target ledger cell is a Boolean value or an enumeration, the following rules apply to the writing of the calculation results: Boolean value If the calculation result is an empty string, a blank value is written. If the calculation result matches `True`, ignoring leading/trailing whitespace and case, `True` is written. In all other cases, `False` is written. Enumeration If the calculation result is an empty string, a blank value is written. Otherwise, the calculation result is considered a label, and the item (the member of the value definition dimension of the enumeration account) in the value list with the same label, ignoring leading/trailing whitespace and case, is written. If there is no such item, a blank value is written. 1. When calculating the value to be reflected in the ledger, English is always applied (even if another language is selected on the client side, the calculation is redone in English on the server side). This is to prevent the write value from changing depending on the language selected on the client side. Generally, form designs that allow the value to be written in the ledger to be affected by the language are not desirable.
Display/editing methods for amounts/numbers	The default display/editing methods for amounts/numbers for each column/row. The actual method applied is determined by arbitration for each combination of column and row specifications.
Format text with markup (fusion_place >= 10.0)	If this item is checked, for ledger cells of string data type in both [Browser] and [Contributor], the string formatted with markup will be interpreted and displayed. For cells without cell specification, if it is checked in either column or row specification, the markup formatting will be interpreted. For cells with cell specification, the specification in the cell specification takes precedence over the same item in the column and row specifications. That is, even if the same item is checked in column and row specifications, the latter’s specification takes precedence if it is not checked in the cell specification. For details on markup, please refer to Supported Markup Formats.
Sign type	Specifies the display method of the sign when displaying amounts/numbers. Follow account attribute Treat debits as `+` Treat credits as `+` The actual sign type applied is determined by arbitration for each combination of column and row specifications. If no sign type is specified in column, row, or cell specifications, the cell’s sign type will default to "Follow account attribute".
Protect cells (prohibit input)	Specifies whether to protect the cell, i.e., to make it input-prohibited. The default is unchecked, meaning "do not prohibit". Even if unprotected, calculation cells cannot be inputted, and for non-calculation cells, the input capability is determined according to the input capability of the associated ledger cell. For cells without cell specification, if it is checked in either column or row specification, the cell will be protected. For cells with cell specification, the specification in the cell specification takes precedence over the same item in the column and row specifications. That is, even if the same item is checked in column and row specifications, the latter’s specification takes precedence if it is not checked in the cell specification.

Data Source

The default data source for each column/row. The actual data source applied is determined by arbitration for each combination of column and row definitions.

Formula

The text expression used to calculate the value displayed in the column/row. The actual formula applied is determined by arbitration for each combination of column and row definitions.

The result of the formula may be a string, not necessarily a number.

Reflect calculated value to ledger

Specifies whether you want the value calculated by the formula^[1] to be written to the ledger (if not specified, the calculated value is displayed only and not written to the ledger).
For writing, each target cell must have a data source (ledger and dimension member) specified completely.
Whether this item is actually enabled is determined according to the arbitration of the formula.

If the data type of the target ledger cell is a Boolean value or an enumeration, the following rules apply to the writing of the calculation results:

Boolean value: If the calculation result is an empty string, a blank value is written.
If the calculation result matches True, ignoring leading/trailing whitespace and case, True is written.
In all other cases, False is written.
Enumeration: If the calculation result is an empty string, a blank value is written.
Otherwise, the calculation result is considered a label, and the item (the member of the value definition dimension of the enumeration account) in the value list with the same label, ignoring leading/trailing whitespace and case, is written. If there is no such item, a blank value is written.

1. When calculating the value to be reflected in the ledger, English is always applied (even if another language is selected on the client side, the calculation is redone in English on the server side). This is to prevent the write value from changing depending on the language selected on the client side. Generally, form designs that allow the value to be written in the ledger to be affected by the language are not desirable.

Display/editing methods for amounts/numbers

The default display/editing methods for amounts/numbers for each column/row. The actual method applied is determined by arbitration for each combination of column and row specifications.

Format text with markup
(fusion_place >= 10.0)

If this item is checked, for ledger cells of string data type in both [Browser] and [Contributor], the string formatted with markup will be interpreted and displayed.

For cells without cell specification, if it is checked in either column or row specification, the markup formatting will be interpreted.
For cells with cell specification, the specification in the cell specification takes precedence over the same item in the column and row specifications. That is, even if the same item is checked in column and row specifications, the latter’s specification takes precedence if it is not checked in the cell specification.

For details on markup, please refer to Supported Markup Formats.

Sign type

Specifies the display method of the sign when displaying amounts/numbers.

Follow account attribute
Treat debits as +
Treat credits as +

The actual sign type applied is determined by arbitration for each combination of column and row specifications.

If no sign type is specified in column, row, or cell specifications, the cell’s sign type will default to "Follow account attribute".

Protect cells (prohibit input)

Specifies whether to protect the cell, i.e., to make it input-prohibited. The default is unchecked, meaning "do not prohibit".
Even if unprotected, calculation cells cannot be inputted, and for non-calculation cells, the input capability is determined according to the input capability of the associated ledger cell.

For cells without cell specification, if it is checked in either column or row specification, the cell will be protected.
For cells with cell specification, the specification in the cell specification takes precedence over the same item in the column and row specifications. That is, even if the same item is checked in column and row specifications, the latter’s specification takes precedence if it is not checked in the cell specification.

Column and Row Display Rules

Item Setting

Item	Setting
Column/Row Title	Specifies the text expression for the string to be displayed as the column/row title. Multilingual specification is possible. To split the column title into more than `2` lines, use `\n` to insert a newline in the string constant (see Text Expressions - Constants for reference).
Suppress Column/Row Display	This item can be used to suppress the display of a column/row when you do not wish to show it (e.g., columns/rows holding intermediate results of calculations).
Suppress Borders	This item can be used to suppress the display of borders surrounding each cell and the column/row title in the column/row. The border between two columns/rows is suppressed only if both columns/rows have been specified to suppress border display.

Column/Row Title

Specifies the text expression for the string to be displayed as the column/row title. Multilingual specification is possible.
To split the column title into more than 2 lines, use \n to insert a newline in the string constant (see Text Expressions - Constants for reference).

Suppress Column/Row Display

This item can be used to suppress the display of a column/row when you do not wish to show it (e.g., columns/rows holding intermediate results of calculations).

Suppress Borders

This item can be used to suppress the display of borders surrounding each cell and the column/row title in the column/row.
The border between two columns/rows is suppressed only if both columns/rows have been specified to suppress border display.