DDSC returns Result Comments for Daily Detail variables (i.e. hourly, 15 Minute…)
DDSC(VarNum,offset, Optional Interval, Optional IntervalNumber)
VarNum: The variable number to get the value for.
Offset/Date:If the field is numeric it is assumed to be the offset and is defined as the offset (number of slots for the variable type) from the start date of the report. For example, if the start date is 1/1/2000 and the offset is 2 the result comment for the 2nd data slot will be returned. I.E. for an hourly variable the comment for the 1AM to 2AM slot will be returned, for a 15 minute variable the comment for the 12:15 AM to 12:30AM slot will be returned. If the offset is 3, the comment for 2AM to 3AM (hourly var). If the field is a date/time in quotes or a cell reference to a cell containing a date/time the sample comment for the slot specified by the date/time will be returned.
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.
||Day of Year|
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.
In Design, Spread Reports use Locate, Daily Detail Values to place this formula on a report.
COM, COMWO, DDSCWO
Start Date of report is 1/1/2000
Variable 1 is an hourly parameter
DDSC(1,2) Returns the result comment for variable 1 for 1/1/2000 1AM Hour (i.e. the 2nd hour of the day).
DDSC(1,"2/7/04 8:22") Returns the result comment for variable 1 for 2/7/2004 8AM Hour. If 2/7/04 is beyond the end date of the report the result comment will still be returned.
DDSC(1,"14:37") Returns the result comment for variable 1 for 1/1/2000 2PM hour slot. If the date is not specified the start date of the report is assumed.
DDSC(1,2,"m",1) Returns the result comment for the 12/1/1999 1AM hour. Go back 1 month (“m”) from the start date and get the 2nd hour of that day.