SUMSTATICVALUES

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

js

SUMSTATICVALUES(cube_name, relative_location)

SUMSTATICVALUES(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

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

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

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