5 Replies Latest reply on Sep 19, 2017 9:14 AM by ryoboyle

    How to set decimal positions instead of use ROUND in OL CDS IR

    juan_martinez

      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