Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Not applicable

Re: How to round 2 numbers after decimal point??

Hai,

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

7 Replies
Not applicable

Re: How to round 2 numbers after decimal point??

Hai,

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

Siva_Sankar
Honored Contributor

Re: How to round 2 numbers after decimal point??

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

MVP
MVP

Re: How to round 2 numbers after decimal point??

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
Not applicable

Re: How to round 2 numbers after decimal point??

Hai  jonathan ,

Thanks for your explanation.

Thanks

Not applicable

Re: How to round 2 numbers after decimal point??

Usefull answer

Not applicable

Re: How to round 2 numbers after decimal point??

float f = 10.123456F;

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

Full Source : round a number to 2 decimal places

Mercal

Highlighted
mkamal
New Contributor

Re: How to round 2 numbers after decimal point??

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