MMIN returns the monthly minimum value of a specified variable.
SYNTAX:
MMIN(Cx, optional Time Increment)
where :
Cx is a conditional variable x
Time Increment Optional - specifies the source variables (Cx) Frequency when the Source Variable (CX) and target variable's (i.e. the variable being calculated) frequencies do not match.
NOTES:
The result is stored in the last day of the month.
The result is stored based on target variables frequency:
EXAMPLE 1: Return the Monthly minimum value from a variable
Source variable (70) is set to Daily and Target variable (112) is also set to Daily. Because both the Source and Target variables are the same (Daily), the time increment BYDAY will be used.
V112 = MMIN(C70)
The minimum value for variable 70 will be stored in variable 112 on the last day of the month.
EXAMPLE 2: Return the Monthly minimum value from an Hourly variable into a Daily Calculation.
Source variable (70) is set to Hourly and Target variable (112) is set to Daily.
V70 - Is a hourly parameter
V112 - Is a daily calculation
V112 = MMIN(V70,BYHOUR)
Note: You MUST specify the Time Increment (BYHOUR) that matches the source variables frequency (IE the source variable V70 is Hourly, therefore we specify BYHOUR) in order for the function to return the correct value.
See: Working with Daily Detail Variables in Calculations.