Which syntax does the CVRC expression use?

Which syntax does the CVRC expression use?

• A. CVRC(ColumnName ColumnIndex RowName RowIndex)
• B. CVRC(RowName RowIndex ColumnName ColumnIndex)
• C. CVRC(RowName ColumnName RowIndex ColumnIndex)
• D. CVRC(RowIndex ColumnIndex RowName ColumnName)

Answer: (B)

The function expects four arguments in a fixed order: the name of the row dimension, the index of the row member, the name of the column dimension, and the index of the column member. This sequence uniquely identifies the cell by its row and column axes. Therefore the correct syntax is CVRC(RowName RowIndex ColumnName ColumnIndex). It means you first specify which row dimension and which row member, then which column dimension and which column member. The other permutations would misplace a name where an index is expected or swap the row and column roles, leading to an incorrect interpretation of the cross-tab values.

The function expects four arguments in a fixed order: the name of the row dimension, the index of the row member, the name of the column dimension, and the index of the column member. This sequence uniquely identifies the cell by its row and column axes. Therefore the correct syntax is CVRC(RowName RowIndex ColumnName ColumnIndex). It means you first specify which row dimension and which row member, then which column dimension and which column member. The other permutations would misplace a name where an index is expected or swap the row and column roles, leading to an incorrect interpretation of the cross-tab values.