Ways to Validate level zero members of Hierarchy in a IF Statement
Summary:
Encountering Issue while validating entire hierarchy in IF Statement.
Content (required):
Hi All,
I wanted to check ,level zero members of Salaries Hierarchy == #Missing in IF Condition.
Used Below methods, which are not working eventually skips the condition resulting in ELSE condition
- IF(@ISMBR(@RELATIVE("Salaries",0)) == #Missing)
- IF(@MEMBERAT(@RELATIVE("Salaries",0)) == #Missing)
- IF(@CURRMBR(@RELATIVE("Salaries",0)) == #Missing
Would like to ways to encounter this issue to check level Zero members in IF Statement.
Please Advise.
Version (include the version you are using, if applicable):
23.06.60
Code Snippet (add any code snippets that support your topic, if applicable):
0