Versions Compared

Version Old Version 4 New Version 5
Changes made by

Migration (Unlicensed)

Migration (Unlicensed)

Saved on

Key

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

Introduction

A reference pick list is a list building block 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
  • Last Month

etc.

Example:

List Attributes

Basic Attributes

picklist

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 DescriptionEmpty

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 pick-list.1, 2, 3, ...

Max + 1

Advanced Attributes

Description coloring.

List Attribute

Default

Description

Available

Values

Default

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

colouring.

No, Yes

No

Reverse Sign

No

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

No