Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Developing a rolling 12 month P&L in RW

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Whitney Johnson
New Member
Posts: 6
New Member
5/15/2012 12:52 PM
    Has anyone developed or can you tell me if I can create in RW a rolling 12 month P&L for finance only showing the Actual amount column for each month? The report would need to run for the current month, but then show the previous actual amounts for the other 11 months.

    Thanks,
    Whitney
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    5/15/2012 1:12 PM
      Whitney,

      That makes my brain hurt just thinking about it. You guys have Reporting Services (as I remember), why not use Crystal instead? I think it would be much easier.
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      amynelson
      Advanced Member
      Posts: 25
      Advanced Member
      5/15/2012 1:12 PM
        Whitney - You are going to us the data dictionary name @CPACT for the current month and then the remaining 11 columns will be @CPACT-1, @CPACT-2, etc.

        Hope this helps.
        Whitney Johnson
        New Member
        Posts: 6
        New Member
        5/15/2012 6:23 PM
          Thanks Matthew!