Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

show in two decimal

Hi  all,

Jyothish KC

Frank Hartmann

i have a column  name is rate  and now values showing as  100.00000455  [ this column is coming from directly from DB]

i want to  get as a  new column with  100.00%

1 Solution

Accepted Solutions
andrey_krylov
Specialist
Specialist

Hi Sony, maybe this

Num(100.00000455, '#,##0.00') & '%'

or this

Num(100.00000455/100, '#,##0.00%')

View solution in original post

4 Replies
andrey_krylov
Specialist
Specialist

Hi Sony, maybe this

Num(100.00000455, '#,##0.00') & '%'

or this

Num(100.00000455/100, '#,##0.00%')

soniasweety
Master
Master
Author

thanks for your response.  second one looks cool

can you have look on below thread.

range

Frank_Hartmann
Master II
Master II

try this:

num(round(100.00000455,0.01)/100,'#.##%')

soniasweety
Master
Master
Author

but it is showing all 100.00% only... as i have data like 99.988  it should not round.

it should show 99.98% ..

and can u have a look into this?

range