Skip to Content
0
Former Member
Aug 05, 2011 at 06:29 PM

Getting the Parent of a member ID

33 Views

The formula below is not returning the parent of a member (as it did formerly).

PAYROLL is a valid application name.

T0013929 is a valid ID:

EVPRO("Payroll","T0013929","ParentH1")

The formula returns the dreaded "#NODATA" result.

Will someone tell me the correct syntax to identify the parent of a dimension ID?

My humble thanks in advance for a probably dumb question with an embarrassingly simple answer.