# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for
Did you mean:
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

Hai,

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

7 Replies
Not applicable

Hai,

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

Master II

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

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

Hai  jonathan ,

Thanks

Not applicable

Not applicable

float f = 10.123456F;

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

Full Source : round a number to 2 decimal places

Mercal

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?

Community Browser