SYNTAX:

DDVTWO(VarNum,offset,Decimal Places,   Optional No Value Print, Optional Interval, Optional IntervalNumber) 

VarNum:  The variable number to get the value for.

Offset: Sets which value to return.  For example, a setting of 1 means return the 1st value found for the dates specfied, 2 means return the 2nd value found, etc… 

Decimal Places:  Set the number of decimal places to display the value to.  Has no effect if it is a text variable.

No Value Print:  OPTIONAL. Sets what to display if value is blank. 

Interval OPTIONAL. Used to retrieve data outside the report date range.  The interval sets whether to go back/forward years (yyyy), months (m), etc…  The following are the valid settings for Interval. 

Interval	Description
yyyy	Year
q	Quarter
m	Month
y	Day of Year
D	Day
H	Hour
n	Minute
w	WeekDay
ww	Week

IntervalNumber: Used with the Interval Setting to set the date to get the comment for.  Sets the number of Intervals to be added to set the dates.  See examples below.

NOTES:

In Design, Spread Reports use Locate, Daily Detail Values to place this formula on a report.

EXAMPLES:

All the examples below use the following data for Variable 11.  Variable 11 is an hourly parameter that allows symbols.

Time	12/1/04	12/2/04	12/3/04
00:00	1.1	>2.1	3.1
01:00
02:00
03:00
04:00	<1.2	2.2	3.2
05:00
06:00
07:00
08:00	1.3	2.3	3.3
09:00
10:00
11:00
12:00 (noon)	1.4	2.4	3.4
13:00
14:00
15:00
16:00	1.5	2.5	3.5
17:00
18:00
19:00
20:00	1.6	2.6	3.6
21:00
22:00
23:00

DDVTWO(11,1,1) = 1.1 Returns the 1st value in the report date range

DDVTWO(11,2,1) = <1.2 Returns the 2nd value in the report date range

DDVTWO(11,7,2) = >2.10 Returns the 7th value

DDVTWO(11,1,1,"",2,”D”) = 2.1 Returns the 1st value for the 2nd day.

DDVTWO(11,7,1,"",1,"D") = "" Returns the 7th value for the 1st day.  Since there is no 7th value on the 1st day, it returns nothing.

DDVTWO(11,7,1,"NO DATA FOUND",1,"D") = "" Returns the 7th value for the 1st day.  Since there is no 7th value on the 1st day, it returns "NO DATA FOUND".