Issue with XRef dynamic Member formula on Smartlist Account Member
Hi All,
I am using Xref function in Dynamic member formula on Account member called "Status_Consol".
"MS_None"->"Budget_Consol"->"STATUS_Consol" = @XREF("_RevCube_","STATUS","1","Budget");
"MS_None" belongs to the dimension that exists only in Target Plan Type and "1" belongs to the dimension which belongs to only source Plan type Budget Maps to "Budget _Consol" and Status Maps to "Status_Consol" All the other Dimensions are same in both Source and Target Plan Types. above mentioned Dynamic Member Formula is on Member "STATUS_Consol" .
Status and "Srtatus_Consol" are both Smartlist type account members and both use same smart list also called status.