Adding Formula Fields to Reports
For financial statements, use the Financial Report Builder to edit columns. See Financial Report Builder Edit Columns Page.
You can click Add Formula Field in the Add Fields pane to add formula-based columns to your report.
Then you can select the formula type and the components (the x and the y) in the Report Preview pane.
NetSuite provides six predefined formulas in the Formula Type field:
-
Sum: x+y
-
Difference: x-y
-
Percent Difference of X: ((x-y)/x)*100
-
Percent Difference of Y: ((x-y)/y)*100
-
Ratio: x/y
-
Percent Ratio: (x/y)*100
-
Multiply: x*y
In the fields provided, you can select columns to use for the X and Y values in the preceding formulas.
You also can choose whether to include a grand total field for the formula column in subtotal rows, and specify how the grand total is calculated:
-
Apply the formula to the subtotal row's X and Y values. This is the default.
-
Sum the formula column values from rows in the subtotal group. To use this method, clear the Apply Formula to Grand Total box.
Reports currently don't support fields based on more complex formulas, like those using SQL functions. Searches support these types of formulas for results and criteria fields. See Formulas in Searches.
To add formula fields to reports:
-
On the Reports page, click Customize next to the report you want to add formula fields to.
-
In the Add Fields pane, click Add Formula Field.
-
In the Formula Type field, select a formula to use to calculate values in the selected column.
-
In the X and Y fields, select the columns to use as X and Y in the formula. For each row, the X and Y columns calculate the value for the formula field column.
-
If needed, check the Add Grand Total box to add formula column grand totals in subtotal rows.
-
If you want formula grand totals to be sums of formula column values, clear the Apply Formula to Grand Total box.
-
Click Preview or Save.
Formula column values in report results are rounded to the currency precision set by the company currency format. If you're using NetSuite OneWorld, the rounding is set by the format of the subsidiary base currency.