User Defined Column Report

The User Defined Column report presents a printable summary of the individual values entered for a given User Defined Column. The values represented are combined totals based on the values entered in both the Direct and Overhead Cost Schedules.

This report becomes useful for reviewing the costs that have been attributed to each value entered in a specified User Column.

User Defined Column Report

REPORT

This report will display the following information:

  • Value (unique value that has been entered into the User Defined column being reported on)
  • Resource Type Breakdown
  • Cost Total
  • Cost % (the percentage of the combined total of Direct and Overhead that is the specific User Define column value)
  • Sell Total
  • Sell % (the percentage of the combined Sell Total of items in the Direct Cost Schedule)
  • Item Count (number of individual Schedule Items that use the specific User Defined column value)

FORMATTING OPTIONS

You can change the format of the data by clicking the Change button, in the bottom left-hand corner in the Options section of the report.

User Defined Column Report - formatting options

FORMATTING OPTION

DESCRIPTION

Displayed User Defined Column

This option allows you to set which User Defined Column will be used to generate the report.

Only one User Defined Column can be added to the report at a time.

Show Displayed Unit Total

The displayed Unit Total field allows you to select a resource unit (such as mhr or m2) to include a summation column for the unit selected.

Only one Unit Total column can be added to the report at a time.

Note: General Report Options are available as standard for this report.