VTWO returns the daily text value when it occurs for a variable. If the variable is setup to allow symbols (ie <, >, ND entries) or is a text parameter, will return the text value.
SYNTAX:
VTWO(VarNum,Offset, Optional Decimal_Places, Optional NoValuePrint)
VarNum: The variable number to get the average for.
Offset:Sets which value to return. For example, a setting of 1 means return the 1st value found in the report dates, 2 means return the 2nd value found, etc…
Decimal_Places: Number of decimal places to display. Ignored for Text Variables.
NoValuePrint: Text or value to print if no value found.
NOTES:
In Design, Spread Reports use Locate, Daily Values to place this formula on a report.
EXAMPLES:
VTWO(11,1,2) Returns the first result (with symbols - <,>...) found in the date range to 2 decimal places.
VTWO(941,2,0,"XXXX") Returns the second result found for variable 941 (a text variable). If a second value is not found, returns "XXXX"