Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-03-08
Reference: Composite Report Rows

Reference: Composite Report Rows

Workday enables you to create these row types in composite reports:
Row
Description
Lookup Data
Enables you to display rows based on filter criteria. The row type works with the business object of the control field columns to determine the data to include in the row. You can associate each control field column with a different business object so you can configure multiple lookup data rows with different
Filter Criteria
.
Example: To display
Revenue
, configure the lookup data row to include all revenue data, such as
All Ledger Accounts
.
Use
Outline Options
 to configure outline structures so you can expand and collapse various levels of data when the report runs. Workday preserves outlining when you export composite reports to Microsoft Excel, enabling you to expand levels of data.
Combine Data
Enables you to display all rows from the control field column so you can apply calculations to the rows.
Configure the
By Value
 prompt in the
Sort
 section to sort the data by total in ascending or descending order. If your
By Value
 selection contains a control field column, you can sort the data logically.
Example: For financial reports, you can understand how your data changes over time by sorting the months logically, such as January, February, and so on.
Dynamic Data
Enables you to use the results of an advanced subreport in your report.
Workday populates the
Map Sub Report Prompts
 grid with prompts from the subreport, and you can configure
Additional Filter Criteria
 using data from the subreport.
Calculation
Enables you to configure calculations that reference other rows, such as:
  • Difference: Subtracts the second value from the first value.
  • Divide: Divides the first value by the second value.
  • Multiply: Multiplies 2 values.
  • PercentIncrease: Returns the difference in percentage of the first value from the second value.
  • PercentRemaining: Returns the percentage remaining after dividing the second value by the first value.
  • Sum: Returns the sum of multiple values.
  • SumRange: Returns the sum of all rows, from the first row to the last row.
You can select the
Return Zero on Error
 check box to determine if the formula is erroneous when the report runs on these calculation types:
  • Divide
  • Multiply
  • Percent Increase
  • Percent Remaining
Empty
Enables you to provide spacing between rows of data or label sections of data.
Workday displays these 3 prompts in the
Advanced
 section when you edit any row type:
Prompt
Description
Style
Enables you to add formatting to the rows in your report. You can select from custom styles, Workday-delivered styles, or create a style using the
Create Formatting Style
 task.
Category
Enables you to configure the row category, such as
Income
 or
Expense Line
, or create a style using the
Create Composite Row Category
 task.
For rows using calculation columns, you must select
For Row Category
 in the
Reverse the Sign
 section.
Options
Enables you to configure display and style options. You can:
  • (Unavailable for empty rows.) Select the
    Hide Analytic Indicator
     check box to hide analytic indicators configured on columns that impact your rows.
  • Hide rows.
  • Reverse number signs.
  • Use the
    Create Conditional Formatting Override
     task to assign styles to true/false conditions.