This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
Respond to this messageReturn to Index
Original Message
  • @ALLOCATE - Close, but not working

      • Posted May 7, 2012 10:49 PM

      I want to spread the difference between actual-to-date and budget in the remaining projected periods in the current year for all overhead accounts. In other words, the total overhead projection for the total year (combo of actual and forecast) should match what was budgeted. The difference changes as every actual period is loaded.

      Something like:


      FIX(@RELATIVE("Total Overhead",0),&FIRST_PROJECTED_PERIOD:DEC,&CURRENT_YEAR)

      &CURRENT_PROJECTION = @ALLOCATE(
      &BUDGET_SCENARIO->YearTotal - Jan:&Last_Actual_Period,
      &First_Projected_Period:Dec,
      1,
      ,
      SPREAD,
      SKIPNONE
      )

      ENDFIX

      But this isn't working. I used "1" for the basismbr argument because I don't think this is used for a Spread allocation type (?).

      Any suggestions?
    Login Status
  • You are not logged in
      • Login
      Password
       

      Optional
      Provides additional benefits such as notifications, signatures, and user authentication.

      Create Account
    Your Name
    Your Email
    (Optional)
    Message Title
    Message Text
    Options Also send responses to my email address
          



    RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.