To find the maximum or the minimum amount in a specified period you use the Interval Maximum and Interval Minimum functions. There are also filtered equivalents of these functions where a value is only included in the aggregation if a given boolean attribute is true at that time. These functions are Interval Maximum If and Interval Minimum If.
In general the result of these functions will not vary over time, however, if time-varying start or end dates are passed in as parameters, the result will vary too.
Find the maximum amount in a period
Find the minimum amount in a period
Find the maximum amount in a period when a boolean attribute is true
Find the minimum amount in a period when a boolean attribute is true
To find the maximum value of a variable in the interval from the specified start date (inclusive) to the end date (exclusive) you use the Interval Maximum function. The syntax for this function is:
For example, to determine the maximum rate of daily benefit calculated between 5 July 2006 and 31 July 2006 (inclusive), you would write the following rule in Word:
the maximum rate of benefit during the assessment period = IntervalMaximum(2006-07-05,2006-08-01,the daily rate of benefit)
This function returns a value of $25 for 'the maximum rate of daily benefit during the assessment period' (p2) for the following data:
To find the minimum value of a variable in the interval from the specified start date (inclusive) to the end date (exclusive) you use the Interval Minimum function. The syntax for this function is:
For example, to determine the minimum rate of daily benefit calculated between 5 July 2006 and 31 July 2006 (inclusive), you would write the following rule in Word:
the minimum rate of benefit during the assessment period = IntervalMinimum(2006-07-05,2006-08-01,the daily rate of benefit)
This function returns a value of $15 for 'the minimum rate of benefit during the assessment period' (p2) for the following data:
To find the maximum value of a variable in the interval from the specified start date (inclusive) to the end date (exclusive), only including times when a boolean filter is true, you use the Interval Maximum If function. The syntax for this function is:
For example, to determine the maximum rate of benefit calculated between 5 July 2006 and 31 July 2006 (inclusive) where the client is also eligible for the benefit, you would write the following rule in Word:
the maximum rate of benefit payable during the assessment period = IntervalMaximumIf(2006-07-05,2006-08-01,the maximum daily rate of benefit,the client is eligible for the benefit)
This function returns a value of $20 for 'the maximum rate of benefit payable during the assessment period' (p6) where b3 is 'the client is also eligible for the benefit' for the following data:
To find the minimum value of a variable in the interval from the specified start date (inclusive) to the end date (exclusive), only including times when a boolean filter is true, you use the Interval Minimum If function. The syntax for this function is:
For example, to determine the minimum rate of benefit calculated between 5 July 2006 and 31 July 2006 (inclusive) for days where the client is also eligible for the benefit, you would write the following rule in Word:
the minimum rate of benefit payable during the assessment period = IntervalMinimumIf(2006-07-05,2006-08-01,the minimum daily rate of benefit,the client is eligible for the benefit)
This function returns a value of $25 for 'the minimum rate of benefit payable during the assessment period' (p8) where b3 is 'the client is also eligible for the benefit' for the following data:
