VAR returns the daily value for a variable.
SYNTAX:
VAR(VarNum,Offset, Optional future, Optional MarkViol, Optional ViolBoldFlag, Optional ViolForeColor, Optional ViolBackColor)
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.
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.
NOTES:
In Design, Spread Reports use Locate, Daily Values to place this formula on a report.
EXAMPLES:
=VAR(1,2,0,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.