$(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
avatar image
Former Member

New formula column for accumulating values (running sum)

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"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 25, 2016 at 10:57 AM

    Can you recreate the formula in the BEx query instead?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 25, 2016 at 12:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2016 at 09:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2016 at 11:39 AM

    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)

    Add comment
    10|10000 characters needed characters exceeded