Hi all,

Is there a way to just select the number of decimal positions in Intelligent Report?.

Round is not a good solution because it does two different things: rounding and hidden ending ceros....

My customer is asking for just select the characters shown in a numeric field, not rounding.

Here you have a good no desirable example, the bottom number should say 0.140 not 0.14.

This is because my customer used a ROUND(expression,3) in that column

By the way the round function in IR tables should also have display decimal positions, not rounding as it is today:

Hope we can find a way to format the number of decimal positions....

Thanks to all for these excellent contributions.

Juan Martinez

If you wish to get trailing 0's then FormatNumber will work fine but it will still round the value. If we change sunny's example a bit

=FormatNumber(1.205,2,True,False,False)

Result is 1.21

If you wish to stop rounding at a specific number of decimal places then the follow works

=Int(1.205*100)/100

Result is 1.20