Versions Compared
| Version | Old Version 1 | New Version 2 |
|---|---|---|
| Changes made by | ||
| Saved on |
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Introduction
A columns list is a list building block that can be used to define the columns for formatted statements like Multi Column reports. This list allows you to format the columns exactly the way you want.
Note: Column formats override row formats. For example: your row is formatted to use scale:thousands and the column is formatted to use scale:percentage, the cell where the row and column cross will be formatted as percentage.
List Attributes
Basic Attributes
List Attribute | Default | Description |
|---|---|---|
Empty | No | By setting this attribute to yes, the column will be shown as empty. This means that no data will be queried and only the label/custom description will be showed. |
Visible | Yes | By setting this attribute to no, the column will be hidden. Hiding a column can be useful for a calculation step in a formula. |
Custom Description | Empty | The custom description overrides the default generated column header. You can use either a fixed text or a Dynamic Label Expression. Use the <BR> tag for a line break. |
Formula | Empty | By specifying a formula this column will be calculated. |
Format | Default Format | The /wiki/spaces/CXO/pages/2806776298 will be specify the look and feel of the column. |
Width | 0 | The width defines the column width in pixels. If you want to leave the sizing to to the report specify 0. |
Order | Max + 1 | Use the order attribute to reorder the columns. |
Advanced Attributes
List Attribute | Default | Description |
|---|---|---|
Header Format | Default Format | The header /wiki/spaces/CXO/pages/2806776298, defines how the column header should be formatted. |
Reverse Valuation | No | When this attribute is set to yes, the Valuation will be reversed. This means negative becomes positive and the other way around. Changing the valuation will influence the variance coloring. |
Reverse Sign | No | When this attribute is set to yes, the sign will be flipped. |
Suppress Value | None | This value sets automatic column suppressing, click on the type to see the suppressing options. |
Variance Threshold | Empty | Threshold value for the Variance (e.g., Actual vs. Budget). If the Variance is less than this Threshold, then a neutral variance color is used (Orange). Otherwise Red (indicating an unfavorable variance) or Green (favorable variance) is used. Use e.g. -200;300 for an absolute threshold or -10%;20% for a relative threshold. |
Suppress Variance | SuppressNoBaseOrReference | Allows you to set the conditions for not suppressing the Variance, by using a pick list |
CONTENT
| Table of Contents |
|---|