Example:
List Attributes
Basic Attributes
List Attribute | Description | Available Values | DefaultDescription | ||
|---|---|---|---|---|---|
EmptyNo | Empty tree members are not shown on the value tree. | Visible | YesNo, Yes | No | |
Visible | By setting this attribute to no, the tree member will be hidden. Hiding a tree member can be useful for a calculation step in a formula. | Yes, No | Yes | ||
Custom DescriptionEmpty | The custom description overrides the default generated name. You can use either a fixed text or a Dynamic Label Expression | FormulaEmpty, Populated | Empty | ||
Formula | By specifying a formula this tree member will be calculated. | Empty, Populated | FormatEmpty | ||
Default Format | The /wiki/spaces/CXO/pages/2806776298 will specify the look and feel of the tree member. | Default, Default_bold, Default_left, ... | Default Format | ||
X Coordinate0 | The X coordinate defines the position of the tree member on the X Axis, see screenshot for the X positions. | 0, 1, 2, 3, ... | 0 | ||
Y Coordinate0 | The Y coordinate defines the position of the tree member on the Y Axis, see screenshot for the Y positions. | 0, 1, 2, 3, ... | 0 | ||
Unary Operator | + | The unary operator defines the symbol (See screenshot) in front of each tree member | , the options are: . | +, -, /, * | + |
Parent ItemEmpty | Select a /wiki/spaces/CXO/pages/2806776443 so that the tree member will be connected with a line to the parent tree member. | Empty, Populated | Empty | ||
Order | Max + 1 | Use the order attribute to reorder the rows. | 1, 2, 3, ... | Max + 1 |
Advanced Attributes
List AttributeDefault | Description | Header FormatAvailable Values | Default | |
|---|---|---|---|---|
Header Format | The /wiki/spaces/CXO/pages/2806776298 will specify the look and feel of the tree member header. | Default, Default_bold, Default_left, ... | Default Format | |
Reverse ValuationNo | 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. | No, Yes | No | |
Reverse Sign | No | When this attribute is set to yes, the sign will be flipped. | No, Yes | No |
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. | Empty, Populated | Empty |
Redirect Report NameEmpty | Use this field to select one of the existing reports that will be available trough a hyperlink. | Empty, Populated | Empty |
Note: When you redirect to a report of type Multi-Column and that report has the same Value Tree List as an Item Selector, the Multi-Column report will automatically select the tree member where it was redirected from.