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

Dynamic Planning Negative Amounts in Reports

  • Dark
    Light
  • 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?