Skip to Content
0
Oct 11, 2012 at 05:49 AM

Carry forward December 2011[prev year] value to January 2012[next year]

26 Views

Hello everyone,

I am using Web Intelligence.

My requirement is :

The user selects the year 2011,2012 and so on as a report level filter and based on that the report is displayed.

Value in January should be January value + December value from previous year,After this the December value should be hidden.

For this I am using running sum : RunningSum([Amount];Row;([G/L Account - Key]))

But the issue is I get correct result only when I select "All Values" in the report level filer,i.e the December value from 2011 does not get added to January 2012 if I select 2012 in my filter.

Please suggest any alternative way.

Thanks in advance.

Puskar Ghosal

Attachments

1.png (37.9 kB)