New formula column for accumulating values (running sum)

[Former Member]

Hi,

I am trying to add a new column that accumulates the values over a key figure (Running sum) vertically like "=SUM($B$4:$B4)" however it is automatically changed to "

"=SUM($B$4:$B22)" (B22 is the end of my table).

I can't use the built in dynamic calculation feature because I also have a dimension horizontally.

Anyone have any suggestions on how to solve problems like this?

I am on version "2.3.2.60825"

[Former Member]

It seems to be the behaviour but I would like to get it confirmed and if there is any possible workaround (Like creating your own formula)

[bverweijen]

Hi Marcus

You mentioned "I can't use the built in dynamic calculation feature because I also have a dimension horizontally.".

Do you know if this is default documented behavior? I also have this requirement of only wanting an accumulative sum across columns, and not across rows.

Kind regards

Bart

[Former Member]

Hi Tammy,

Thank you for your answer!

Absolutely however we have continuous new requirements from end users doing similar things but for different key figures in different analytical areas. Since we are not allowed to change queries directly in production I was hoping for a more versatile solution through the new "add a column" concept than having to go through the whole transport process and frustration and wait it leads to for the end user.

If I understand correctly it is not possible to do a formula in this manner? Do you know of any documentation which contains the limitations for making your own formulas?

Best regards

Marcus

[TammyPowlas]

Can you recreate the formula in the BEx query instead?