Home : DDVTWO
Q11280 - INFO: DDVTWO
DDVTWO returns values as text (values with symbols/data qualifiers or text entries) for Daily Detail variables (i.e. hourly, 15 Minute…) when they occur.

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". 

 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 6/2/2008 10:44 AM.
Last Modified on 10/1/2010 12:09 PM.
Last Modified by Scott Dorner.
Article has been viewed 3094 times.
Rated 2 out of 10 based on 2 votes.
Print Article
Email Article