VT returns the daily text value for a variable.  If the variable is setup to allow symbols (ie <, >, ND entries) or is a text parameter, VT will return the text value. 

SYNTAX:

VT(VarNum/Where Clause,Offset/Date, Optional Interval, Optional IntervalNum, Optional NoValuePrint, Optional Decimal Places)

VarNum/Where Clause:  Specifies the variable to get text value for.  Can be a variable number, a cell reference to a variable number or a Variable WHERE Clause.  

Offset/Date: If the field is numeric it is assumed to be the offset and is defined as the offset from the start date of the report.  For example, if the start date is 1/1/2000 and the offset is 1, the value from 1/1/2000 will be returned.  If the offset is 2, the value from 1/2/2000 will be returned and so forth.  If the field is a date in quotes or a cell reference to a cell containing a date the value for the date will be returned.  If the offset calculates a date beyond the end date of the report data will not be returned (use optional Interval and IntervalNum).  If the offset is 0 or negative it will calculate a date before the start date of the report and this function will return data before the start date.

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

yyyy    Year
q         Quarter
m        Month
y         Day of year
D        Day
w        WeekDay
ww      Week

IntervalNum:  Used to retrieve data outside the report date range.  The interval number set the number of Intervals to go back. 

NoValuePrint:  Text or value to print if no value exists.  If set to "COMMENT", the result comment for the variable/date will be displayed if no value exists for the day.

Decimal Places:  Number of decimal places to display.

 

NOTES:

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

EXAMPLES: