Hi Experts,
Im trying something like aggregating the few members in a hierarchy to Parent entity California. Here, In current hierarchy I want to aggregate only few members from A888001 to A888010 and want to exclude remaining members for first IF condition. Please see the below Hierarchy and rule which I have written. But its not aggregating the specified members. Please let me know where Im missing it.
| A888000 | Califirnia | Amount | |
| A888001 | Sunnyvale | 5,353 | |
| A888002 | Sunnyvale | 73,633 | |
| A888003 | Sunnyvale | 31,231 | |
| A888004 | Sunnyvale | | |
| A888005 | Sunnyvale | 7,373 | |
| A888006 | Sunnyvale | 9,883 | |
| A888007 | Sunnyvale | 63,453 | |
| A888008 | Sunnyvale | 63,256 | | Balance_Validation( |
| A888009 | Sunnyvale | 63,767 | | IF(@ISMBR("Sunnyvale")) |
| A888010 | Sunnyvale | | | "A999003" = @SUMRANGE("A888001":"A888010"); |
| A888011 | Sunnyvale | | | ELSEIF (@ISMBR("Sunnyvale")) |
| A888012 | Sunnyvale | 83,633 | | "A999003" ="A888019"->"York"; |
| A888013 | Sunnyvale | | | ELSEIF (@ISMBR("Sunnyvale")) |
| A888014 | Sunnyvale | 738,738 | | "A999003"="A888020"->"EB Velly"; |
| A888015 | Sunnyvale | | | ENDIF; |
| A888016 | Sunnyvale | | | ) |
| A888017 | Sunnyvale | 6,353 | |
| A888018 | Sunnyvale | | |
| A888019 | York | 388,939 | |
| A888020 | EB Velly | 8,899 | |
| A888021 | Newport | 54,543 | |
| A999003 | | 1,599,054 |