Analytics Software

Hi,

Please find the code below. I am trying to capture current weeknumber in wks variable and use it in @MATCH to traverse to other weeks

But i am getting the error:

Detail:Cannot calculate. Essbase Error(1200400): Error executing formula for [COL] (line 31): scalar double argument expected in function [@EQ]

Please help.

FIX(@LEVMBRS(Period,0))

"COL"
(
IF("Addition"<>#MISSING AND @PRIOR("Addition")==#MISSING )

IF(COL_Wks<>0)
"COL"->@CURRMBR(Period)="Addition";
COL_Wks=COL_Wks-1;
Wks=3;

IF( @MATCH("Period", "Wk?")==Wks)

"COL"=@PRIOR("COL")*(1-@PRIOR("Wkly_Trng_Attr%"));
COL_Wks=COL_Wks-1;
Wks=Wks+1;

ENDIF;

ENDIF;

ENDIF;

);

ENDFIX

Thanks,
Srinivas