INT (x)

Description:

This function rounds a number down to the nearest integer.

Syntax: INT(Number)

Number

• Number : Enter a number or a range in a PowerOLAP cube for which you want the value rounded to the nearest integer.

Remarks

• The number argument is compulsory.
• If a text value is specified instead of a number value, then PowerOLAP returns a "0" as the result.
• Number is the real number you want to round down to an integer.

Example

The INT function can be used in any database where you have stored a value for which you want to calculate the integer part of the given number then, it is possible to do that with the help of this function. This function displays the Integer value of any number specified in a formula or as a range in a cube and this is the number that is the parameter given to the function.

=INT (9.99)	-INT of the given positive number (9)
=INT ("text-value")	-INT of a text value returns zero value is returned because text is an invalid argument for this function.
=INT (-9.99)	-INT of the given negative number (-10)
=INT ("range")	-INT of the number in that range.

 

Let us take the example of a cube in PowerOLAP which has data which is the information in numbers for which you want to calculate the whole integer value. If in the same dimension in another member or in another dimension in another cube, you want to display these calculated values for the number parameter, then it is appropriate to use the INT function to calculate the INT for the number. In this case we can write a formula in the cube in PowerOLAP to pull in values from one member of a dimension of a cube and write them to the formula and derive the values for the other member of the dimension, or you can even do this for a different dimension in a different cube.



The formula above writes values into the "NumFunctionValuesData" cube to the "INT" member in the NumFunctionValues dimension (data is at the intersection with the MathValue member of the Version dimension). This is done by calculating the integer value for the number in the "InputNumber" member of the "NumFunctionValues" dimension. The INT function takes the "InputNumber" member which is a number given to the function as a parameter and it converts this value to its Integer value and the calculated result is written into the same cube in the "INT" member of the "NumFunctionValues" dimension.