Home : MVVNWO
Q11493 - INFO: MVVNWO

MVVNWO returns variable number of the Xth value (where X is set by Offset) from a series of values.

SYNTAX:

MVVNWO(Offset, VarNum1, VarNum2, ...,VarNum99)
MVVNWO(Offset, "Where Clause")
where :
Offset sets which date to return, (i.e., date of 1st Value, 2nd Value, etc...)
VarNum1, VarNum2,...,VarNum99 is a comma separated list of variables that sets which variable to search.
"Where clause" : Instead of providing a list of variables, you can use an SQL Where clause against the VarDesc table to get the list of variables.  (i.e., "Units = 'mg/L'" would return all variables with Units set to mg/L.  See examples.

NOTES:

All variables listed MUST have the same frequency (i.e., daily, hourly, ...).

EXAMPLES:

Data Input:

Example functions and their results:

See Also: MVDWO

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 8/15/2008 11:07 AM.
Last Modified on 8/15/2008 11:52 AM.
Last Modified by No Author Name Available!.
Article has been viewed 1850 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article