CONTAINSSTATICVALUES ^v2.7.116

Returns true if the cell or its children being calculated has a non-formula driven, non-zero value.

js

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

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

Note: Assuming the cell or its children have a user or process entered value this will return true.