Eclipse Reports provides a way to refine data for your report if the standard column values do not meet your needs. Add or edit formula columns to represent values based on other column data, as needed.
For example, you can add a GP/Margin (gross profit/margin) calculation to any report that gives you price and cost.
To add a formula to a report:
Create a report or open a report in edit mode.
From the Sample Report Data tab, select the column before which you want to insert a formula column
From the Edit menu or using a right-click, select Insert a Formula Column.
The Formula Editor displays with the available columns.
In the Header field, enter a name for the column you are adding, such as Markup.
In the Formula field, create the formula to refine your data by clicking the column header in the list to load it and adding formula properties, such as plus or minus signs where needed. You can also drag and drop a column name from the Available Columns area.
For example, you want to display the total sales amount minus the cost of goods sold. Set your formula as follows:
Click OK to apply the formula.
The formula column displays with the title and the associated calculations.
Repeat steps 3 - 6 to add additional formulas to the report.
Click Save to save the formula.
Return to the report display and adjust the column placement or format the results, as needed.
To edit a formula:
Create a report or open a report in edit mode.
From the Sample Report Data tab, select the column for which you want to change a formula.
From the Edit menu or using a right-click, select Edit a Formula Column.
The Formula Editor displays with the available columns.
In the Formula field, edit the formula as needed.
Click OK to apply the formula changes.
The formula column displays with the title and the associated calculations.