Skip to Content
0

Round function issue in report?

May 07 at 05:48 PM

18

avatar image
Former Member

Hi Friends,

I have to display round values in reports. kindly help to resolve this,

i want to display

if 57.50 = 58.00

4559.86 = 4560.00

like above.

i have used now round(column_name) .


pls help to resolve this,

Mani.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dell Stinnett-Christy May 07 at 09:18 PM
0

Actually, try Round({MyTable.MyField}, 0) to get it to round to the nearest whole number then format the number display of the formula to show two numbers after the decimal.

-Dell

Share
10 |10000 characters needed characters left characters exceeded
Jyothirmayee A May 07 at 05:55 PM
0

Hi,

Try: Round(Column_name,2) to get 2 place decimals.

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded