This discussion is archived
3 Replies Latest reply: Oct 8, 2013 8:42 AM by F. Arabak RSS

Calc Error "Error(1200337) - Error compiling formula"

F. Arabak Newbie
Currently Being Moderated

I have created a scenario "AnnualizedActuals" with the following calc:

 

FIX ("Final", &CurrYr);

AnnualizedActuals

(

IF ("Period" == "Jan")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Jan")/1)*12;

ELSEIF ("Period" == "Feb")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Feb")/2)*12;

ELSEIF ("Period" == "Mar")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Mar")/3)*12;

ELSEIF ("Period" == "Apr")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Apr")/4)*12;

ELSEIF ("Period" == "May")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"May")/5)*12;

ELSEIF ("Period" == "Jun")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Jun")/6)*12;

ELSEIF ("Period" == "Jul")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Jul")/7)*12;

ELSEIF ("Period" == "Aug")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Aug")/8)*12;

ELSEIF ("Period" == "Sep")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Sep")/9)*12;

ELSEIF ("Period" == "Oct")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Oct")/10)*12;

ELSEIF ("Period" == "Nov")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Nov")/11)*12;

ELSEIF ("Period" == "Dec")

  "AnnualizedActuals" = (@Sumrange("Period","Jan":"Dec")/12)*12;

ENDIF

)

ENDFIX;

 

When verifying I get the following error:

 

Error(1200337) - Error compiling formula for [AnnualizedActuals] (line 3): [)] without [(]

 

I have reviewed my parentheses and they look correct. Any ideas?

 

Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points