COUNTSTATICVALUES

Returns the COUNT of user input values. Ignores calculated values from formulas.

js

COUNTSTATICVALUES(cube_name, relative_location)

COUNTSTATICVALUES(cube_name, relative_location)

Parameters

cube_name - The cube to source information from.
relative_location - The relative location in the target cube. The relative location needs to specify each of the elements of dimensions which exist in the source cube which do not exist in the destination cube.

Examples

js

COUNTSTATICVALUES("Profit and Loss", ["Amount", "All Months"])

COUNTSTATICVALUES("Profit and Loss", ["Amount", "All Months"])

Note: Will return the Count of user entered values across all months.