VAROPV returns the daily value for a variable.
SYNTAX:
VAROPV(VarNum,Offset, Decimal_Places, Optional MarkViol, Optional ViolBoldFlag, Optional ViolForeColor, Optional ViolBackColor, Optional No_Value_Print)
VarNum: The variable number to get the value for.
Offset: The offset from the start date of the report. For example, if the start date is 1/1/96 and the offset is 1, the value from 1/1/96 will be returned. If the offset is 2, the value from 1/2/96 will be returned and so forth.
Decimal_Places: Sets the number of decimal places to display.
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 to place this formula on a report. See Optional Print Tab - Edit/View Variables for information on how to setup the Optional Print.
EXAMPLES:
=VAROPV(1,2,2,1,1,255,65535): Display the value for variable 1 for day 2 of the report. Mark violations as bold, red (255 is the RGB color code for red) forecolor, and yellow (65535 is yellow) backcolor.