Previous  Next          Contents  Index  Navigation  Glossary  Library

Rounding in Default Columns

The expressions used to define the default PSI columns provided with Oracle Projects include a rounding factor of zero (round to the nearest whole number). For example, the definition of ITD - Act Rev (ITD actual revenue) is:

If you want decimal values (cents, for example) to appear in the ITD actual revenue figure, you change the final zero to a higher number (2 for cents, or 3 if you want to see fractions of cents).

If the ROUND expression is present but no value is given for the rounding factor, the expression is rounded to 0 decimal places.

You should use rounding in each expression, particularly if the expression includes a calculation.

Note: The ROUND expression will work only if you have not checked the Currency checkbox for a PSI column in the PSI Columns window. If you check the Currency checkbox, the column displays amounts based on the currency format defined in Oracle General Ledger.

         Previous  Next          Contents  Index  Navigation  Glossary  Library