Error executing formula for (line 16): attempt to cross a null member in function

@X]

Summary

Error executing formula for [LCL] (line 16): attempt to cross a null member in function [@X]

Content

Hi Gurus,

 

I am using Essbase 11.1.2.4 version and I was getting an error like "Error executing formula for [LCL] (line 16): attempt to cross a null member in function [@X]" when I am running calculation script which is having an IF statement syntax like below:

 

 

IF(@ANCEST(@CURRMBR(&quot;Product_SKU"),-1,"Level 0 Account")->one of Level 0 Entity <> #Missing)

                    "LCL"->"Rate_SRC"->"No_Material" = 1;

                    "LCL"->"CosRate_EPMLvl" = @ANCEST(@CURRMBR(&quot;Product_SKU"),-1,"CosRate_EPMLvl")->one of Level 0 Entity;