Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I imagine this is a pretty straight forward thing to fix.
I have the below expression in a text box:
='No of Products
' & Sum(TOTAL)
Which returns the below:
As you can see it is giving me back a seemingly infinite amount of decimal places, How do I get the above expression to just return 32 as the value?
Any help is greatly appreciated
Thanks,
round(sum(TOTAL))
you can go to the numbers tab, select that expression and then on the right, you can then define the field type, and optionally the number of decimal points
Hi Scholar
You can use Num() function
Following is from the help menu in Qlikview
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 |
round(sum(TOTAL))
On the Document Properties, Numbers tab, you can set the default format for the TOTAL field as an integer, then all occurrences of TOTAL will be formatted as integers.
You can set defaults for all your number , date & time fields in this list
hi,
Please try:
Select integer in Number tab to truncate decimal places
This is perfect for what I need. Thank you!