stop the rounding

[mwa]

I have a number field in my table that contains a value such as:

0.3573

I want to display 2 decimal places, not rounded, like this:

0.35


CR9 allows you to format the field on the report to change the # of decimal places shown, but I can't get it to stop rounding and only show two decimal places. All I can seem to get is:

0.36

Any ideas on how to do this?

mwa
<><

 

[synapsevampire]

Here's a cheat:

whileprintingrecords;
Stringvar TextNum := totext({table.field});
val(left(TextNum,instr(Textnum,".")+2))

-k

 

[bdreed35]

You can create a formula like this that truncates it and then turns it into a string:

totext(truncate(0.3573,2),2)

~Brian

 

[mwa]

Thanks...

sv: yours didn't seem to work. I still get .36

bd: yours does work. Thanks...

mwa
<><