VARWO returns the daily value for a variable.
SYNTAX:
VARWO(VarNum,Offset, Optional future, Optional MarkViol, Optional ViolBoldFlag, Optional ViolForeColor, Optional ViolBackColor, Optional No_Value_Print)
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 in the report dates, 2 means return the 2nd value found, etc…
Future: Not Used
MarkViol: Set to 1 to mark violations (based on variables limits) if they occur. How they are marked depends on the next settings.
ViolBoldFlag: Set to 1 to bold violations.
ViolForeColor: Sets the foreground color of cells that contain violations. Number represents a RGB color code (0 to 16,777,215).
ViolBackColor: Sets the background color of cells that contain violations.
No_Value_Print: Text string to print if no value found.
NOTES:
In Design, Spread Reports use Locate, Daily Values and select the Print Data only when it occurs option to place this formula on a report
EXAMPLES:
=VARWO(1,2,2,1,1,255,65535): Display the second value found in the report data range.