How to have integer format in a TEXT Object

Thu, 05 Nov 2015 12:05:53 GMT

Hello,

I have an expression in a text box which results\bring me a number. This number is in the following format XX.YYYYYYYY

I would like to change the format, in the text object so that I will only see 2 characters after the Dot (Decimal point)

For example, if the result of the expression is 0.03892852 I would like to present in the text object only 0.03

Again, I know there is a property called Number in a chart object but It does not exist in text box.

In addition, I tried using the Ceil option but it change such a result 0.03892852 to 1 which is unwelcome.

Any Idea, workaround which be appreciated.

Nir

Re: How to have integer format in a TEXT Object

Anonymous — Thu, 05 Nov 2015 12:07:43 GMT

num(0.03892852, '0.##' )

Thu, 05 Nov 2015 12:43:23 GMT

Thank you, I was close enough!