topic Re: How to round 2 numbers after decimal point?? in QlikView

How to round 2 numbers after decimal point??

jsingh71 — Thu, 29 Nov 2012 05:09:55 GMT

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

Thu, 29 Nov 2012 05:32:44 GMT

Hai,

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

Siva_Sankar — Thu, 29 Nov 2012 05:38:36 GMT

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

jonathandienst — Thu, 29 Nov 2012 05:43:12 GMT

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

Thu, 29 Nov 2012 05:45:49 GMT

Hai jonathan ,

Thanks for your explanation.

Thanks

Fri, 13 Feb 2015 05:12:31 GMT

Usefull answer

Tue, 09 Jun 2015 06:59:09 GMT

float f = 10.123456F;

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

Mercal

mkamal — Mon, 07 Jan 2019 22:03:21 GMT

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

vvvvvvizard — Mon, 24 Jan 2022 11:29:33 GMT

'##,00'

Felipeaviolin — Thu, 22 Sep 2022 18:38:05 GMT

Thanks !