Round upto 2 decimal points

KReporter
1

Hello,

We have kreport with cost column. It is showign around 6 digits after decimal point. How could we round up to 2 decimal points in the report?

2

Isn’t the field of type currency?
That should round up to the preference “currency significant digits” or at least to 2 digits after the decimal separator.

If your field is not if type currency, try to override the type in the presentation Tab.

If that doesn’t work try with an SQL customFunction:
ROUND({t}.{f}, 2)

1 Like