• Search Forums
    Advanced Search
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
 24 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!