Reference: Composite Report Cells
You can set up these cell types in your composite report to increase the depth and focus of your report. The contents of the intersecting column and row types determine the actions available in each cell.
Cell | Description |
|---|---|
Label | Enables you to set up labels, such as Total Number of Employees , at the intersection of a control column and empty row.
You can define labels using text expressions and variables. Workday replaces the variables in the text expressions with the values of the variables when the report runs. Example: Workday replaces [V1] with the date in the text expression Last updated on [V1]. |
Data | Enables you to retrieve data from your subreport at the intersection of a:
You can:
Executing subreports for each data cell might impact the performance of the composite report. |
Calculation | Enables you to use calculation and data columns in your report to set up calculation cells that reference other cells using these functions on the expression builder:
You can use calculation cells with outlining. For these functions, Workday defaults Return Zero on Error to true unless you specifically set it to false:
Select the Hide Analytic Indicator check box to hide visual representations configured on columns that impact your cells.Workday uses the standard order of operations rule, known as PEMDAS, for mathematic expressions and reads functions from left to right:
|
Conditional Value | Enables you to override the value of an undefined cell at the intersection of a lookup data row and data column. You can set up the cell to display zero or the actual value based on whether the condition is true or false. |
Conditional Format | Enables you to override the style and visibility of an undefined cell. |