Home : VPIC Spread Function
Q14508 - INFO: VPIC Spread Function
VPIC returns the picture for a daily picture type variable. 

SYNTAX:

VPIC(VarNum, Offset/Date)

VarNum: The variable number to get the average for.

Offset/Date: If the field is numeric it is assumed to be the offset and is defined as the offset from the start date of the report. For example, if the start date is 1/1/2000 and the offset is 1, the value from 1/1/2000 will be returned. If the offset is 2, the value from 1/2/2000 will be returned and so forth. If the field is a date in quotes or a cell reference to a cell containing a date the value for the date will be returned.

SEE ALSO:

Locate>Daily Values, Format>Format Cell

EXAMPLES:

In the following examples, Variable Number 100 is setup as a Daily, Picture type variable. 

VPIC(100,1) - Retrieves the picture for Variable Number 100, day 1 of the report.

VPIC(100,"6/11/2018") - Retrieves the picture for VarNum 100 for June 6th, 2018.

VPIC(100,B5) - Retrieves the picture for VarNum 100 for the date in cell B5

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 7/30/2018 12:14 PM.
Last Modified on 7/30/2018 1:10 PM.
Last Modified by Scott Dorner.
Article has been viewed 412 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article