Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have text box expession sum(Amount) ,so my value is 292.0356565 .I want only Integer values 292 ,I realy appriciate would clear this solution .
Hello,
You can use the NUM function:
Num(
Sum(Amount)
, '# ##0', '', ' ')
Hope this helps,
Quentin
Hello,
You can use the NUM function:
Num(
Sum(Amount)
, '# ##0', '', ' ')
Hope this helps,
Quentin
NUM(Sum(Value),'# ##0')
Please refer to QlikView Manual....
num(expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )
The num function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the number format set in the operating system is used.
Example:
The examples below assume the two following operating system settings:
Default setting 1 | Default setting 2 | |
Number format | # ##0,# | #,##0.# |
num( A, '0.0' ) where A=35648.375 returns:
Setting 1 | Setting 2 | |
String | 35 648 375 | 35648.375 |
Number | 35648375 | 35648.375 |
num( A, '#,##0.##', '.' , ',' ) where A=35648 returns:
Setting 1 | Setting 2 | |
String | 35,648.00 | 35,648.00 |
Number | 35648 | 35648 |
num( pi( ), '0,00' ) returns:
Setting 1 | Setting 2 | |
String | 3,14 | 003 |
Number | 3.141592653 | 3.141592653 |
Thanks
Hi,
To erase the decimal part, you can use
Floor(Sum(Amount))
To get the nearest entire value, you can use
Round(Sum(Amount))
Hope this helps