Skip to Content
avatar image
Former Member

Round function issue in report?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 07 at 09:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 07 at 05:55 PM

    Hi,

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

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded