Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use the Num() function
=Num(YourExpression, '#,##0.00')
Hi
try this
=num(fieldname,'#.##')
fieldname - it can be an expression too
Or this to floor your value
Floor('43.539290780812', 0.01)
try like this
num('43.539290780812','######0.00')
or
num(field_name,'######0.00')
=floor(YourExpression, 0.01)
Thanks Sunny
It's working
Thank you very much you all
Thanks,
AR UMAMAHESH