Reports

Set rounding to less than 1 on a table inserted from Additional Disclosures

  1. Step 1 — Set the rounding on the table
  2. View the table.
  3. Select
    Design
    to open Design view.
  4. Double-click on the table to open the
    Design Smart Table
     window.
  5. Select
    TableOptions
    .
  6. In the Table Options window, on the
    Options
     tab, select the ellipsis button next the
    Rounding
     box.
  7. In the
    Options
     expression box, replace
    Rounding
     with the format for figures that you want, followed by the letter
    m
    .
    note
    For example, enter
    0.0001m
     to round figures to 4 decimal places.
  8. Leave
    Scaling
     entered in the
    Scaling
     box.
  9. Leave
    Table wrapping direction
     blank.
  10. Select
    OK
     to save your changes.
  11. Step 2 — Set the rounding on the individual cell
  12. Return to viewing the table in the
    Design Smart Table
     window.
  13. Right-click over the amount that needs the rounding changed and select
    Form
    , then
    Cell
     from the context menu.
  14. In the
    Cell Properties
     window, select the
    Number
     tab.
  15. Change the value in the
    Format
     box as needed. For example, 0.0000.
  16. Select
    OK
    , then
    OK
     again to return to the report.
  17. Select
    Preview
    , then
    Full report
    .
The values will now display as required.

This article applies to:

  • Product: Digita Accounts Production Advanced
  • Subject: Reports