3 Replies Latest reply: Oct 8, 2013 10:42 AM by F. Arabak RSS

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

    F. Arabak

      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!