SAP Community - Planned Downtime - Sunday, August 14, 2022

There will be a planned 8-hour downtime on Sunday, August 14 starting at 10 am CEST; 4 am EDT until 6 pm CEST; 12 pm EDT. During this time, Answers and blogs will function but subscription-related features, such as following a tag, will not function.

Jan 15, 2021 at 09:29 AM
# Dynamic moving cell calculation using cell references in query designer

Dear guys, I am faced with the following issue: I created a query with two structures to use the cell editor. One structure is a pure fiscper structure using offsets. The other keyfigure structure uses formulas/selection. My problem now: Due to rolling fiscal periods the formulas in the cell editor have to be adjusted dynamically depending on the fiscal period in the column.

For example:

Column M is calculated using M12+L11+K11

Now column N is calculated using L11+M12+N12 (so just move one right and one row down)

Due to moving fiscal periods the formula has to adjusted each rolling months as we only visualize the last 13 months.

How could I do such a dynamic change of calculation without manual adjustment of the formula each month?

Tried to use "help cells" but not knowing how these should be implemented to use them.

Would be glad about any hints here.

Thanks so far.

Regards,

Peter