How can we specify Rounding methods in Actuate 7?

[kinnukm]

Hi,
I have a problem specifying the rounding method for decimal fields. When I format the fields to 2 decimal places, Actuate always rounds UP.
Is there a way where I can tell Actuate to Round-UP or Round-DOWN for decimal values.

Eg. Round-UP : 56.236 = 56.24
Round-DOWN : 56.236 = 56.23

Thanks

 

[myty1998]

I posed this question a few months ago - this was the reply I received and the Fix( ) worked for me.

"You can either use a database function (if your rdbms has one) so that it is faster, or you can use Actuate's Fix( ) or Int( ); either will truncate any decimal places, returning only the integer portion, without rounding...