Using column definition hpw to format column with %

Question

Using Column Definition in Business Central, how do I format one of the columns to have a percent sign(%) instead of a dollar sign($) on a financial report?

Answer 1

Hi @Richard E. Wheeler

Go to Financial Reports
Open your report (e.g., Balance Sheet, Income Statement)
Go to Column Definitions
Select the column you want to change
Find the field Format
Change it from:
Amount
Currency
Standard
<blank>  
to:
✔ Use this format code for percent:
Code
% 
or the more explicit:
Code
Percent
or the numeric formatting version:
Code
0.00%

Thanks.

Answer 2

In Business Central financial reports, set the percentage in the column definition formula instead of using a currency symbol.

Steps:

1. Open Financial Reports.
2. Select the financial report.
3. Choose Edit Column Definition.
4. On the target column:
   • Set Column Type to Formula.
   • In Formula, enter the source column followed by %.
     • Example: if column N contains the net change, enter N%.

This makes that column display values as percentages rather than dollar amounts.

If the report is using Financial Reporting-style column definitions, percentage formatting can also be applied through Format/Currency override:

1. Open the column definition.
2. Double-click the Format/Currency override cell for the amount column.
3. In Format override, select percentage formatting.

---

• Column definitions in Financial Reporting
• Work with financial reports
• Column definitions in financial reports