Database Reference
In-Depth Information
To D I S PL Ay
ForMuLA
r E Su LT
Same day last
year
(year-1).day
Current date (month and day) for
last year. For example, if the current
date were December 10, 2010, then
(year-1).day
would show informa-
tion for December 10, 2009.
Same month last
year
(year-1).month
Current month for last year. For
example, if the current month were
December, 2010, then
(year-1)
.month
would show information for
December, 2009.
Same range of
a period of six
months last year
(year-1).
(month-5):
(year-1).
(month)
From 18 months ago to one year
ago. For example, if the current
month were December 2010, then
(year-1).(month-5): (year-1)
.month
would show information for
the time period ranging from June
2009 to December 2009.
Same range of
months to date
for last year
(year-1).
firstmonth:
(year-1).month
From the first month of last year up
to and including the month parallel
to the current month this year.
Year to date
yeartodate
A single time period representing
the aggregation of values from the
beginning of the year up to and
including the last completed period.
The period corresponds to the most
specific time period defined for the
data source.
Year to date (by
month)
yeartodate.
fullmonth
A single time period representing
the aggregation of values from the
beginning of the year up to and
including the last completed month.
Year to date (by
day)
yeartodate.
fullday
A single time period representing
the aggregation of values from the
beginning of the year up to and
including the last completed day.
Parallel year to
date
yeartodate-1
The aggregation of the same set of
default time periods completed in
the current year except for the prior
year.
Although all the examples in Table 11-1 are lowercase, STP is not case sensitive,
and you may find that casing the formula elements makes them easier to read.
For instance, instead of year, put Year, and use FirstMonth instead of firstmonth.
