Planned Downtime Announcement

September 25, 2021 รขยย There will be a two-hour planned downtime on Sunday September 26th, starting at 6:00 pm CEST (12:00 pm ET; 9:00 am PT). Please save your work.

Oct 18, 2005 at 02:23 PM
# Formula calculation in BEx

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=4*13*8 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