Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

how to display two decimal points in text object

Hi all

Example:

Count(sales) = 100.345625678  (in Text object)

How can i show two decimal points in text object

6 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

=Num(Count(sales), '0.00', '.', ' ')

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
manojkulkarni
Partner - Specialist II
Partner - Specialist II

num(count(sales)),'#,##0.00')

arulsettu
Master III
Master III

try this

=num(Count(sales),'#,##0.00')

madhubabum
Creator
Creator
Author

Hi

Thanks ....

It's working fine

Thanks

Madhu

jsingh71
Partner - Specialist
Partner - Specialist

 

Under Textbox text write:

 

=Num(100.345625678,'#.## ')

or if you want to use any field then mention your field name like

=Num(Field_name,'#.## ')

arulsettu
Master III
Master III

you are welcome. please mark it as answer if it works.