Hello,

Instead of the following can you hard code a member and see if it works?

@MEMBER(@CONCATENATE("MISC-",@NAME(@SUBSTRING(@NAME(@CURRMBR("Product")),2,6)))

Hi,

You don't need the outer @NAME. @CONCATENATE("MISC", @SUBSTRING(....)), should do the work.

SUBSTRING returns a string, while NAME takes an essbase "member" parameter which you are getting using @CURRMBR.

Thanks,

Pawan.

Hi As a first step can you try below code. This iwll ensure if the condition to check Gross sale = #missing or 0 is working or not.

FIX("Actual","FINAL", @RELATIVE("Total Departments",0))

"SGA Account"

(

  IF( "SGA Account"->"Customer_NA"->"ProductTarget" <> #MISSING)

         IF("Gross Sales"==#Missing or "gross sales"==0)

        @return(@hspnumtostring("Gross Sales"),error);

ENDIF

ENDIF

)

Hi,

Per the doc you cannot use @CURRMBR on the left hand side of a formula. Fix on MSC-XXX and have it equal to @MEMBER(@CONCATENATE("P_",CONCATENATE(@SUBSTRING(@NAME(@CURRMBR(Product)),6),"0"))).

You could use a variable to create the required member name and just use @MEMBER(<P_Product>)->"SGA"->"Customer_NA"->"ProductTarget";

Regarding your latter code, when you say it doesn't work, is it because of validation error?

Thanks,

Pawan.