Skip to Content
0
Jul 10, 2015 at 12:21 PM

mathematical calculation in only one keyfigure between different months

11 Views

Dear All,

I have to do mathematical calculation in only one keyfigure between different months

My scenario is :

There is a field called BalanceSheet for a perticular G/L is coming from ECC/BPC into BI cube.

Currently the data is coming like:

G/L Jan2015 Feb2015 Mar2015

1003029 10 30 40

The value is cumulative in the coming month(i.e. the value has addition of prev. month's data also)

Now the requirement is user does not want the cumulative data. so the output should be like:

G/L Jan2015 Feb2015 Mar2015

1003029 10 20 10

I have checked it with cell restriction but we would have to do it for required months so that cud not be dynamic.I have even tried with formula variable but it is the same case.

I have searched in google as well as SCN but no clues.

Kindly suggest.

Regards,

Anu