

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to round 2 numbers after decimal point??
Hi Everyone,
I write one expression in Text Object Expression. Now I got result '86.656982' like this.
I want to round this number like 86.66.
How I do this??
- Tags:
- new_to_qlikview
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hai,
use Num(sum(sales),'##.00') ,It wil give you only two decimal points.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hai,
use Num(sum(sales),'##.00') ,It wil give you only two decimal points.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ajit, Use round( x [ , base [ , offset ]]) . Find the screenshot it will help. Regards. Siva Sankar K


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
If you need to round the numbers properly, use:
=Round(86.656982, 0.01)
Using Num() will change the display format, but does not round off the underlying number. So:
Round(86.656982, 0.01) = Round(86.660001, 0.01)
Num(86.656982, '#0.00') <> Num(86.660001, '#0.00')
Hope that helps
Jonathan

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hai jonathan ,
Thanks for your explanation.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Usefull answer

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
float f = 10.123456F;
float fc = (float)Math.Round(f * 100f) / 100f;
Full Source : round a number to 2 decimal places
Mercal

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
question, this only visually rounded the number. If need to round for a if then statement evaluation. Can you please recommend a solution?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
'##,00'

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks !
