topic Decimal value problem in a text box object? in QlikView

Decimal value problem in a text box object?

saumyashah90 — Fri, 22 Mar 2013 10:58:54 GMT

Hey i want to put two values after decimals.

For Example for 7945694.2234

I want 7945694.22 in my text box object.

I tried it using "Num Floor and Left"-->shows nothing after decimal

I also Tried It using "Subfield"-->shows nothing after decimal.

Even tried Num(),'#.##' or 0.00-->Gives 00 after decimal

kaushiknsolanki — Fri, 22 Mar 2013 11:02:25 GMT

Hi,

Try this.

=num(7945694.2234,'#,##0.00')

Regards,

Kaushik Solanki

Fri, 22 Mar 2013 11:05:55 GMT

try this

num('7945694.2234' ,'#.00','.',',')

or simply write this

num('7945694.2234', .00,'.',',')

sushil353 — Fri, 22 Mar 2013 11:43:28 GMT

use Round Function:

=Round(7945694.2234,0.01) will return 7945694.22

HTH

Sushil

Fri, 22 Mar 2013 15:13:37 GMT

U can use...

=NUM(7945694.2234,'##.##')