MENU
    Dynamic Planning Negative Amounts in Reports
    • 1 Minute to read
    • Dark
    • PDF

    Dynamic Planning Negative Amounts in Reports

    • Dark
    • PDF

    Article summary

    Dynamic Planning supports native Microsoft Excel negative number selections. In Report Design mode, select the report, right-click and select Format Cells as shown below.

    ModelingImages401to450image435.png

    When the Format Cells dialog page is displayed, select the Number tab and then select the Number or Currency Category as shown below.

    ModelingImages401to450image436.png

    Select a negative number format and click OK. Save the report in SpotlightXL.

    Note:
    Displaying negative numbers in black versus red and with or without parenthesis is supported for Number and Currency formats.

    Was this article helpful?