Dimensionality() returns the number of dimensions for the current row.
Syntax:
Dimensionality ( )
Return data type:integer
Limitations:
This function is only available in charts. The number of dimensions in all rows, except the total which will be 0, will be returned.
Example:
A typical use for dimensionality is when you want to make a calculation only if there is a value present for a dimension.
| Example | Result |
|---|---|
|
For a table containing the dimension UnitSales, you might only want to indicate an invoice is sent: |
|