VOPVWO Returns the daily value or optional print value for a variable when data is found.
SYNTAX:
VOPVWO(VarNum,Offset, Optional Decimal Places, Optional MarkViol, Optional ViolBoldFlag, Optional ViolForeColor, Optional ViolBackColor)
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…
Decimal Places: Sets the number of decimal places to be displayed.
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.
NOTES:
In Design, Spread Reports use Locate, Daily Values and select the "Print Data only when it occurs" option and the Print Optional Print value if threshold is crossed" option to place this formula on a report
EXAMPLES:
=VOPVWO(1,2,2,1,1,255,65535): Display the second value found in the report data range.