ELWEIGHT function#

ELWEIGHT returns the weight of a child element within a consolidation - used in weighted roll-up calculations.

Signature#

=ELWEIGHT("Server:Dimension", parent, child)

#	Argument	Type	Required	Permitted values and notes
1	`Server:Dimension`	String	Yes	`"server:dimension"`.
2	`parent`	String	Yes	The consolidated element. A numeric value warns but is accepted.
3	`child`	String	Yes	The component element whose weight you want.

ELWEIGHT takes exactly three arguments. The default result is 0.

For the shared error model and the Calc Mode effect, see how Reportworq handles errors.

Situation	Result
More than three arguments	Hard error
Fewer than three arguments	Warning, `0`
`child` is not actually under `parent`	Warning, `0`
Dimension or element not found	Warning, `0`

=ELWEIGHT("PlanTM1:Region", "North America", "Northeast")

IBM Planning Analytics functions - the function index and the shared error model.
ELISCOMP function - test whether one element is a component of another.

Comments, questions, requests, or something missing or unclear? Email us - the page you are on is filled in for you.