Ways to Validate level zero members of Hierarchy in a IF Statement
Encountering Issue while validating entire hierarchy in IF Statement.
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.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):