Home : SRSTAT
Q14536 - INFO: SRSTAT
 

SRSTAT returns Sampling Requirement statistics (count of results, percent complete...) for a sampling Requirement ID/Name.   

SYNTAX:

SRSTAT(ID/Name, Stat, ForDate

ID/Name: The ID (SAMPLEREQ.ID field) or the Sampling Requirement name in quotes.  Can be a number (i.e. 12), a cell reference (i.e. C2) to a cell that contains a number or string or  a quoted string that is a Sample Requirement Name.

Stat:  The field to get:

  1. Count
  2. %Complete
  3. DaysInGroup
  4. DaysIn
  5. DaysRemaining
  6. StatusCalc
  7. NumReq

 

ForDate:  The function by default looks up the Sampling Requirement for the Start Date of the report.  A date string (i.e. "07/16/2014") or reference to a cell with a date in it, the sampling requirement will be used for this date.

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 5/23/2019 5:32 PM.
Last Modified on 1/13/2021 4:20 PM.
Last Modified by Scott Dorner.
Article has been viewed 1919 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article