Home : VAR
Q10716 - INFO: VAR
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.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 2/7/2008 9:24 PM.
Last Modified on 6/3/2008 10:24 AM.
Last Modified by Scott Dorner.
Article has been viewed 2441 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article