$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
0

New formula column for accumulating values (running sum)

Nov 25, 2016 at 09:22 AM

91

avatar image

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"

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Tammy Powlas
Nov 25, 2016 at 10:57 AM
0

Can you recreate the formula in the BEx query instead?

Share
10 |10000 characters needed characters left characters exceeded
Marcus Larsson Nov 25, 2016 at 12:07 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Bart Verweijen Dec 02, 2016 at 09:01 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Marcus Larsson Dec 02, 2016 at 11:39 AM
0

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)

Share
10 |10000 characters needed characters left characters exceeded