Home : VOPVWO
Q11302 - INFO: VOPVWO
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. 

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 6/3/2008 5:03 PM.
Last Modified on 8/3/2021 1:55 PM.
Last Modified by Scott Dorner.
Article has been viewed 1807 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article