This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

@MOVSUM

June 6 2012 at 7:08 AM
No score for this post
 
from IP address 168.164.246.251


Response to How to pull past 12 months

How about something like this (assuming Years and Months are in seperate cubes, and FY11 is your first year, and Jan is your first month:

@MOVSUM("AccountToSum",12,@XRANGE(FY11->Jan,FY21->Jan));

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: @MOVSUM - Charl on Jun 6, 7:09 AM
    1. Just remember that BegBalance buggers everything - Cameron Lackpour on Jun 6, 12:01 PM
     

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.