IFSHORTER
- Last UpdatedJan 25, 2024
- 2 minute read
The IFSHORTER() function evaluates whether or not a logical expression is true over a period shorter than a specified time interval, and returns a TRUE or FALSE value or stream.
|
Format |
Stream = IFSHORTER(StreamLogicalExpression, Interval) |
|
Arguments |
StreamLogicalExpression - A logical expression to be evaluated Interval - The time interval over which the expression's state is compared |
|
Description |
The expression represented by StreamLogicalExpression is evaluated, and if it remains TRUE for less time than the specified Interval, the boolean TRUE is returned. Otherwise the boolean FALSE is returned. |
|
Format |
Stream = IFSHORTER(StreamLogicalExpression, Interval, TrueStream) |
|
Arguments |
StreamLogicalExpression - A logical expression to be evaluated Interval - The time interval over which the expression's state is compared TrueStream - A stream of values from which to select when the expression evaluates to TRUE for less time than the length of the specified interval |
|
Description |
The expression represented by StreamLogicalExpression is evaluated, and if it remains TRUE for a period of time less than the specified Interval, the corresponding value from TrueStream is selected. If it is not TRUE, a "bad quality" value is selected. |
|
Format |
Stream = IFSHORTER(StreamLogicalExpression, Interval, TrueStream, FalseStream) |
|
Arguments |
StreamLogicalExpression - A logical expression to be evaluated Interval - The time interval over which the expression's state is compared TrueStream - A stream of values from which to select when the expression evaluates to TRUE for less time than the length of the specified interval FalseStream - A stream of values from which to select when the expression evaluates to TRUE for the length of the specified interval or longer |
|
Description |
The expression represented by StreamLogicalExpression is evaluated, and if it remains TRUE for less time than the specified Interval, the corresponding value from TrueStream is selected. Otherwise the corresponding value from FalseStream is selected. |