Database Reference
In-Depth Information
General conventions
uu
When no offset is specified, the current period is assumed.
uu
Using a time period with an offset along with a function requires the use
of parentheses.
uu
Casing of formulas does not impact formula evaluation or meaning.
uu
White-space does not impact formula evaluation or meaning.
uu
Time period including “to date” permits the use of offsets.
uu
Formulas should use singular nouns rather than plural nouns (e.g., year
not years)
Syntax Elements
Operators (Table 7-3), time periods (Table 7-4), and functions (Table 7-5) are
used to create TI formulas.
TABle 7-3
Operators
oPErATor
uSE
.
The period or “dot” operator delimits time periods from func-
tions. The string in front of the dot always corresponds to the
time period. The string following the dot always corresponds
to the time period function.
Example:
year.firstMonth
+
or
-
The plus (
+
) and minus (
-
) operators are used to determine
the offset relative to the current date. Use the minus sign (
-
)
to specify time periods in the past. Use the plus sign (
+
) to
specify time periods in the future.
Example:
day-1
()
Parentheses are used to group a time period and its offset
when you use them together with a function. Required.
Example:
(year-1).firstMonth:(year-1).month
,
Commas are used to delimit multiple time periods in the same
formula.
Example:
year, Quarter, Month, day
The colon operator (
:
) specifies a range of time periods.
Example:
day:day-4
:
