crystal rounding report problem

[eli13]

why is my crystal report rounding it, when i need the 2 decimal place that are not rounded even the hundredths place is more than 5

1606.515 - i want to see the report as 1606.51 but it always shows the 1606.52. grrrr!!

can anyone help me out?

 

[Turkbear]

Hi,
Try converting to text for display and use a pattern
to limit what is shown...
Ypu can still use the actual value ( display hidden) if needed for calculations.
Try

ToText({field},'#####.##')
If Number is
1606.515
this will display
1606.51




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[eli13]

thank you, i'll try it, but last time i tried to convert it as a text file with no pattern, and it didn't work, thanks,

 

[TeyBrady]

Try Truncate({field},2)

 

[eli13]

variable numberVar or stringvar?

 

[eli13]

hey, i figured out the problem, my database, it doesn't round the sum so and transfers a 3 decimal point number, so i round them in the database and it work, my only problem today it the grand total if one of them is 0.00 the salary should not be added in the total, yet it is added.