rounding off the display 1

[saran26]

Hi,

In my report, I am displaying a number with decimal values. I need to display only two decimal values after rounding off. Is it possible ? please let me know.

Thanks
Saran

 

[lbass]

Right click on the number->format field->number tab->customize->choose the decimals and the rounding.

-LB

 

[saran26]

Hi LB,

Thanks for the Info.

When I right click the field , I see only the following tabs
Common, Border, Font, paragraph and hyperlink.

I dont see the numbet tab. Am I missing some thing?

Thanks
Saran

 

[lbass]

Sounds like your field is a string, so first convert it into a number by using a formula:

tonumber({table.string})

-LB

 

[saran26]

Thanks again.

It is displaying properly now.

Saran