Expression Syntax

The following table lists the default syntax for Report section items.

Table 101. Report Expression Syntax

Report Element	Syntax
Table Dimension	CurrBreak.Value["Column Name"] “Column Name” refers to the dimensional column name. The column name can be modified.
Table Fact	Tables["Section"].Columns ["Column Name"].Sum[currBreak] “Section Name” refers to either the Results or Table section. Column Name refers to the fact column name. Sum refers to the return of underlying values and can also be an applied Data functions such as Avg, Max, and Min.
Group Label	CurrBreak.Value["Column Name"] “Column Name” refers to the dimension or fact column name.
Group Fact	Tables["Section"].Columns ["Column Name"].Sum[currBreak] “Section Name” refers to either the Results or Table section. “Column Name” refers to the fact column name. To apply a break at the parent level (the highest level), use the following syntax: Tables["Section Name"] .Columns ["Column"].Sum[currBreak. Parent]