Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to limit the decimals in Text Object

HI all

How to limit the decimals in Text Object


i got 43.539290780812 for my calculation

‌I need to show 43.53 in text object

Can any one help me to solve

thanks

AR UMAMAHESH

1 Solution

Accepted Solutions
sunny_talwar

Use the Num() function

=Num(YourExpression, '#,##0.00')

View solution in original post

7 Replies
sunny_talwar

Use the Num() function

=Num(YourExpression, '#,##0.00')

ankit777
Specialist
Specialist

Hi

try this

=num(fieldname,'#.##')

fieldname - it can be an expression too

sunny_talwar

Or this to floor your value

Floor('43.539290780812', 0.01)

avinashelite

try like this

num('43.539290780812','######0.00')

or

num(field_name,'######0.00')

Kushal_Chawda

=floor(YourExpression, 0.01)

Not applicable
Author

Thanks Sunny

It's working

Not applicable
Author

Thank you very much you all


Thanks,

AR UMAMAHESH