@(ISMBR) and @(Member) in a IF statement not working
Hi All,
I have a calc script where I need some help. I was wondering if someone has come across a similar issue. I am trying to copy data from one member to another. I am working on the shared hierarchies and that might be the issue. Can someone let me know if the IF statement is correct?
Thanks
FIX(@Relative(DIM1SharedHierarchy,0), @Relative(DIM2SharedHierarchy,0))
"DIM4Member"(
IF(@ismbr(@Member(@concatenate("B_", @Concatenate(@substring(@name(@parent(@currmbr(Dim1))),5,8),":0000000000"))) ))
"NoComp_Proj"=NoDIM2;
)
ENDFIX