CountPassFail
Counts and returns passes, failures and total events for a given referenced value.
Inputs
| Parameter | Description | ||||||
|---|---|---|---|---|---|---|---|
|
Event |
Specifies the event on which to increment the counter. This parameter needs to be a reference to any event with a timestamp, for example, one of the following: |
||||||
|
Value |
Specifies a required reference to the cell containing the source of
the data stream to be counted. The counter that is incremented (Pass, Fail or #ERR) is based on the returned Value, as follows:
|
||||||
|
Reset |
Forces the counters to reset at the next event. Specifies whether the counters are reset to zero when the specified Event occurs. This parameter automatically references the Reset button, which is inserted into the spreadsheet when the function is initially created. Note: If this checkbox is manually toggled in the Property Sheet, the reference to the Reset button is removed. To use the Reset button, this parameter must reference the cell containing the Reset button.
|
Outputs
|
Returns |
A Count data structure containing the incremented counters or #ERR if any of the input parameters are invalid. |
|||||||||||||||
|
Results |
When CountPassFail is initially inserted into a cell, a result table and a Reset button are created in the spreadsheet. When the Reset button is pressed, all counters are reset to zero. The following Clocked Data Storage Vision Data Access functions are automatically inserted into the spreadsheet to create the result table:
|