Custom Report > Layout > Column Properties or Add Calculation Column > Calculation tab

Show expandable text

Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

When defining a custom report, you can include one or more user-defined or "calculation" columns. Use the Calculations tab in the Add Calculation Column dialog to define the formula for a new user-defined column in a custom report, and use the Calculations tab in the Column Properties dialog to modify the formula for an existing user-defined column.

To review or modify the properties for an existing column in a custom report, click the Properties button on the Custom Report Layout dialog.

To create a new user-defined column in a custom report, click the Calc'd Column button on the Custom Report Layout dialog.

See also: Creating a custom payroll report

Special information

  • Setup Example 1 in the Payroll CS Tutorial provides an example setup of a custom payroll report. (An active Internet connection is required to open this guide in the Adobe Reader.)
  • The values available in the Selected fields to use in the calculation pane are those numeric fields currently selected in the rows/columns in layout pane of the Custom Report Layout dialog. If a value 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 system in combination with values that you enter.
  • You can apply mathematical operators (add, subtract, multiply, or divide) when creating the formula.
  • By default, when you print or view the report, the program completes each component of the calculation by proceeding from left to right. You can, however, choose to make the calculation honor the order of operands instead (performing multiplications first, for example).

Top of page

Fields & buttons

Top of page

Was this article helpful?

Thank you for the feedback!