MIN (expr, expr, …, expr, expr)

Description:

This function returns the smallest value in a set of values.

Syntax: MIN (number1, number2,…)

• Number1, Number2, … : are 1 to 30 numbers for which you want to find the minimum value.
• Number : Enter a number or a range in a PowerOLAP cube from which 2 or more values you want to compare and from amongst them determine the minimum value.

Remarks

• At least one number argument is compulsory.
• If a text value is specified instead of a number value, then PowerOLAP returns a "0" as the result.
• You can specify arguments that are numbers, empty cells, logical values, or text representations of numbers. Arguments that are error values or text that cannot be translated into numbers cause the function to return a 0.
• If the arguments contain no numbers, MIN returns 0 (zero).

Example

The MIN function can be used in any database where you have stored values that you want to compare with each other and amongst those values the MIN value is returned then it is possible to do that with the help of this function. This function displays the maximum value from 2 or more numbers that are specified as parameters to the formula or it can be numbers in a range in the cube.

=MIN (9.99, 10.99)	-MIN value amongst the two given positive numbers (9.99)
=MIN ("a","b")	-MIN value amongst the two given text values (always "0")
=MIN ("range1", "range2")	-MIN value amongst the two number values that exist in the ranges referenced in the function.

 

Let us take the example of a cube in PowerOLAP which has data which is the information in numbers amongst which you want to calculate the "MIN" value. If in the same dimension in another member or in another dimension in another cube, you want to display the calculated MIN value for the number parameters, then it is appropriate to use the MIN function to calculate the MIN value between the numbers. In this case we can write a formula in the cube in PowerOLAP to pull in values from 2 or more members of a dimension of a cube and write them to the formula and derive the values for the other member which holds the MIN value or you can also do this for a different dimension in a different cube.



The formula above writes values into the "NumFunctionValuesData" cube to the "MIN" member in the NumFunctionValues dimension (data is at the intersection with the MathValue member of the Version dimension). This is done by calculating the MIN value from the two parameters given to the function.

The parameters belong to the "NumFunctionValuesdimension. The MIN function takes the "NUMBER1" and the "NUMBER2" members as the parameters which are given to the function and it calculates the MIN value from amongst these members and the calculated result is written into the same cube in the "MIN" member of the "NumFunctionValues" dimension.