Skip to Content
0
Former Member
Oct 18, 2005 at 02:23 PM

Formula calculation in BEx

104 Views

I have a report:

Item//Per1//Per2//Per3

income//25//36//52

costs//21//23//09

adj costs//4//13//8

Now I need a row like the below:

LTM adj costs//25//19//11 (25=4138 i.e. adding all the adj costs from present to last 2 periods) similarly 19 and 11 assuming the previous period adj costs values are 2 and 5.

NOTE: Items are from the structures in the rows and periods are offsets for Posting periods in the column.

How can I calculate or define the LTM adj costs.

Please let me know if I am clear.

Thanks,

Nikki