Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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??

1 Solution

Accepted Solutions
Highlighted
Not applicable

Hai,

use   Num(sum(sales),'##.00') ,It wil give you only two decimal points.

View solution in original post

7 Replies
Highlighted
Not applicable

Hai,

use   Num(sum(sales),'##.00') ,It wil give you only two decimal points.

View solution in original post

Highlighted
Master II
Master II

Ajit,   Use round( x [ , base [ , offset ]]) . Find the screenshot it will help.  Regards. Siva Sankar K

Highlighted

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Not applicable

Hai  jonathan ,

Thanks for your explanation.

Thanks

Highlighted
Not applicable

Usefull answer

Highlighted
Not applicable

float f = 10.123456F;

float fc = (float)Math.Round(f * 100f) / 100f;

Full Source : round a number to 2 decimal places

Mercal

Highlighted
Contributor III
Contributor III

question, this only visually rounded the number.  If need to round for a if then statement evaluation.  Can you please recommend a solution?