Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

A reference pick list is a list building block that  that can be used to select reference categories. Reference categories are used for variance analysis with the main category of a report. Most reports have a reference pick list. Most reference pick lists contain dimensions like:

  • Year
  • Period
  • Category

CONTENT

Table of Contents

And contain values like:
  • End of Last Year
  • Budget
  • Previous month
  • Previous year
    • Last Month

    etc.

    Example:

    Image Added

    List Attributes

    Basic Attributes

    List Attribute

    Description

    Available

    Values

    Default

    Description

    Empty

    No

    Empty lines will not be visible, if you set this attribute to yes.

    No, Yes

    No

    Custom Description

    Empty

    The custom description overrides the default generated name. You can use either a fixed text or a Dynamic Label Expression

    Empty, Populated

    Empty

    Order

    Max + 1

     Use the order attribute to reorder the members in the
    picklist.
    pick-list.1, 2, 3, ...

    Max + 1

    Advanced Attributes

    List Attribute

    Description

    Available

    Values

    Default

    Description

    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

    colouring.

    No, Yes

    No

    Reverse Sign

    No

     When this attribute is set to yes, all the reference data will be sign flipped.
    CONTENT
    No, Yes
    toc

    No