MinMax calculation
The detailed planning MinMax calculates for each period the smallest or the largest of up to three parameters for each time period.
Typically this calculation is used to generate non-reporting internal values to feed into another calculation.
Parameters
The parameters that the MinMax calculation uses depend on the option you choose in the Function parameter.
- Function: Determines the type of calculation. The options are Max, Min, and MinMax.
- Max or Min: Max returns the largest value, Min the smallest, from among the following parameters.
Source value 1
Select Value to enter a numeric value; selecting any of the others presents a list of the currently defined objects of that type. The options are Value, Attribute, Calculation, and Global Vector.
Source value 2 and Source value 3
Select Value to enter a numeric value; select None to exclude the parameter; selecting any of the others presents a list of the currently defined objects of that type. The options are None, Value, Attribute, Calculation, and Global Vector.
- MiniMax: Compares the Source value to Min Value and Max Value; if source falls within their values the source is returned; otherwise the parameter to which it is closest in value is returned.
Source Value
Select Value to enter a numeric value; selecting any of the others presents a list of the currently defined objects of that type. The options are Value, Attribute, Calculation, and Global Vector.
Min Value and Max Value
Select Value to enter a numeric value; select None to exclude the parameter; selecting any of the others presents a list of the currently defined objects of that type. The options are None, Value, Attribute, Calculation, and Global Vector.
Examples
Max
The following example shows the results returned when Function is Max, Source value 1 is set to 5,000, and the other sources contain various values:
| Jan2017 | Feb2017 | Mar2017 | ... | Jan2018 | Feb2018 | Mar2018 | |
|---|---|---|---|---|---|---|---|
| Source value 1 = 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | |
| Source value 2 = Commission Cap | 1,000 | 2,000 | 8,000 | 1,000 | 2,000 | 10,000 | |
| Source value 3 = Department Min | 4,000 | 7,000 | 4,000 | 4,500 | 7,500 | 4,500 | |
| Calculation Result | 5,000 | 7,000 | 8,000 | 5,000 | 7,500 | 10,000 |
MiniMax
The following example shows the results returned when Function is MiniMax, Source Value is set to 5,000, and the Min and Max sources contain various values:
| Jan2017 | Feb2017 | Mar2017 | ... | Jan2018 | Feb2018 | Mar2018 | |
|---|---|---|---|---|---|---|---|
| Source value 1 = 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | |
| Source value 2 = Commission Cap | 1,000 | 2,000 | 8,000 | 1,000 | 2,000 | 10,000 | |
| Source value 3 = Department Min | 4,000 | 7,000 | 4,000 | 4,500 | 7,500 | 4,500 | |
| Calculation Result | 4,000 | 5,000 | 5,000 | 4,500 | 5,000 | 5,000 |