@SPARENVAL did not work

Hello everyone,

I am having trouble with @SPARENTVAL and need help from you. Thanks in advance.

I have an alternate hierarchy with the WI_AD_PRO_EXP as the parent of the shared members (column B) :

Now, I am trying to use @SPARENTVAL to get data from WI_AD_PRO_EXP and spread it from column I to Column M

"WhatIf Calculation 02" = @SPARENTVAL(@CURRMBR(Account),"WhatIf Calculation 06");

However, it did not give me any result.

Based on the standard document:

I don't know what step I am missing.

I searched on the community, and someone said that we could use an undocumented function called @SPARENT. However, when I tested this function, it did not give me any result either.