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

number formatting....showing upto two places after decimal

hi

i am facing a situtation in which i have to show upto two values after decimal for a particular row in a pivot table....

if i use num('a','#.#')

it will display all the values after decimal. how can i restrict it to two values only.....

e.g 134.57

2 Replies
Sokkorn
Master
Master

Hi,

Try num('a','#.#0')

Regards,

Sokkorn

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Num(a,'#,##0.00') should do it.

Hope this helps,

Jason