When defining a custom report, you may define a new column for the report, using customized calculations.
To open this dialog, click the Add Calculated Column button in the Custom Report Layout dialog.
If a value that you want to include is not available for selection in the Custom Report Layout dialog, you can create a formula that uses one or more values from the application in combination with values that you enter.
- You can apply mathematical operators (add, subtract, multiply, or divide) when creating the formula.
- When you print or view the report, Fixed Assets CS completes each component of the calculation by proceeding from left to right.
- Because a calculated column is, by definition, a numeric column, the column width cannot be modified.
Fields & buttons
Enter one or two lines of the text as you want it to appear in the heading for this user-defined column.
Mark this checkbox if you want Fixed Assets CS to calculate and display the total for this user-defined column.
Select a field to insert into the formula box, followed by the specified function.
As you make your selections, the items in the formula you are creating appear in the Formula box at the bottom of this dialog.
When you print or view the report, Fixed Assets CS completes each component of the calculation by proceeding from left to right.
Click a mathematical operator button to insert into the formula box, followed by the specified field.
As you make your selections, the items in the formula you are creating appear in the Formula box at the bottom of this dialog.
When you print or view the report, Fixed Assets CS completes each component of the calculation by proceeding from left to right.
Button |
Description |
Keyboard equivalent |
|
Add |
+ |
|
Subtract |
- |
|
Multiply |
* |
|
Divide |
/ |
|
Undo the previous action |
ALT+U |