New Global Variable dialog

Use this dialog to add (or modify) a global variable to a formula in the "Edit Column Formula dialog: Column Formula tab."

For more information, see:

This dialog is also displayed as:

Edit Global Variable dialog

Components

Name

Use this text box to enter a name for the global variable. For example, gv_region, date_and_time_global_variable, or rev_eastern_region_calc_gv. See Table 2-1 in Chapter 2, "Syntax for Referencing Variables" for syntax requirements.

Note:

Note that the name for a global variable must be fully qualified when referencing the variable, and therefore is prefixed by the text "global.variables". For example, a global variable set to calculate revenue displays in the Column Formula dialog as follows: "Base Facts"."1- Revenue"*@{global.variables.gv_qualified}

Type

Use this list to specify the data type for the global variable. There are five data types:

Date (default format: mm/dd/yyyy)
Date and Time (default format: mm/dd/yyyy hh:mm:ss)
Number
Text
Time

Value

Use this text box to specify the value for the global variable.

The following are some examples:

06/05/2013 (when the Date type is the data type)
12/27/2011 12:00:01 (when Date and Time is the data type)
3.14159 (when Number is selected as the data type)
05:16:00 (when Time is selected as the Data Type)
((("Base Facts"."1- Revenue"/"Base Facts"."2- Billed Quantity")*3)+500)/-.25 (when Text is selected as the data type and the column is a calculation)