Highest Since Was True [HighestSinceTrue]

Return to Complete List of Functions

The Highest Since Was True function returns the highest value of a data series since a given condition was last true, beginning with the value when it was last true. Parameters ------------------ Data            The data to analyze. This is typically a field in a data series or a calculated value. Condition     The condition to evaluate. This is typically a field in a data series or a calculated value. Function Value ------------------------ This function returns the highest value of a data series since a given condition was last true, beginning with when it was last true. A condition is considered to be true if it has a non-zero value. Prior to the first true value, the function returns the maximum of the highest value in the data series and zero. Note: To return the highest value of the condition since its last non-zero value, specify that value as both the Data and the Condition.