Report Layout Table

The report layout table defines the calculation formula for the profit-and-loss report. A report layout table contains the following columns and must conform to the following rules:

Position
Name Maximum Length Description
1
ID Char 32

The unique identifying reference for the item

  • IDs for source costs are based on the behavior IDs
  • IDs for calculated values are defined here
2
Name Char 32 The name of the behavior, which displays on the report
3
Formula Char 255 For calculated rows, the formula for the calculation based on the IDs
4
RowOrder Numeric 8 The position of the row in the profit-and-loss report

Note: You can add labels to a report.

The following picture shows a sample report layout table:

Note: Do not include calculated rows, such as the following row, in the report hierarchy table:

The following picture shows the relationship between this sample report layout table and the resulting report: