Returns the index of the selected dimension of a specified loop or of the selected simulation.

Syntax

=MM_DIMINDEX("Name")

• "Name"
  String.
  Case 1: Name of the loop whose index you want to access.
  Case 2: Choose Name equal to "SIM" if you want to access the index of the selected stochastic simulation.

 Warning: The parameter LoopName is case sensitive.

Remark

See MM_INSTINDEX the equivalent function for instances. 

Example 1: Loop

Formula1: =MM_LOOP("Loop",C3:C6)
It creates a loop named Loop, which corresponds to all product types.

Formula2: =MM_DIMINDEX("Loop")
It returns the selected index of Loop.

Below, the selected index is 3. Thus, the value returned is 3.

Below, the selected index is 4. Thus, the value returned is 4.

Example 2: Simulations

Formula3 :=MM_DIMINDEX("SIM") returns the index of the selected simulation. As shown below, the first cell of the table which contains the MM_DIMINDEX formula, returns 3 i.e. the index of the selected simulation.

On a side note, the second cell is a generated random number (you cannot select a simulation if your table does not contain stochastic formulas).