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