Value Tree List
Example:
List Attributes
Basic Attributes
List Attribute | Description | Available Values | Default |
|---|---|---|---|
Empty | Empty tree members are not shown on the value tree. | No, 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 Description | The custom description overrides the default generated name. You can use either a fixed text or a Dynamic Label Expression | Empty, Populated | Empty |
Formula | By specifying a formula this tree member will be calculated. | Empty, Populated | Empty |
Format | The format will specify the look and feel of the tree member. | Default, Default_bold, Default_left, ... | Default Format |
X Coordinate | 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 Coordinate | 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. | +, -, /, * | + |
Parent Item | Select a list item so that the tree member will be connected with a line to the parent tree member. | Empty, Populated | Empty |
Order | Use the order attribute to reorder the rows. | 1, 2, 3, ... | Max + 1 |
Advanced Attributes
List Attribute | Description | Available Values | Default |
|---|---|---|---|
Header Format | The format will specify the look and feel of the tree member header. | Default, Default_bold, Default_left, ... | Default Format |
Reverse Valuation | 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 | When this attribute is set to yes, the sign will be flipped. | No, Yes | No |
Variance Threshold | Threshold value for the Variance (e.g., Actual vs. Budget). If the Variance is less than the 1st threshold value, then Red (indicating an unfavorable variance) is used. If the Variance is greater than the 2nd threshold value, then Green (favorable variance) is used. And if Variance is between the 2 threshold values, Orange (neutral variance) is used. Use, for example, -200;300 for absolute thresholds or -10%;20% for relative thresholds. | Empty, Populated | Empty |
Redirect Report Name | Use this field to select an existing report that will be available through 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.