Skip to main content
Question

Cumulative field

I am looking on how to create a field that will show the running total of a certain field. I saw this https://haversineconsulting.quickbase.com/db/bnab4bvnx?a=q&qid=1&_ga=2.126707979.728167338.1559232320-1369865748.1557428883 and it is the one I'm looking for. But I can't seem to understand how to recreate the Cumulative Sum field. Could someone explain this to me in a simpler way? I'd really appreciate it. 
    This topic has been closed for replies.

    Here is a link to Dan's Code:

    https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=614&rl=cgzu

    Doing it this way will give the exact result as shown in the URL you posted. Make a Rich Text Formula Field and use this code:


    "<img src onerror='window.QBU_Sum = (window.QBU_Sum || 0) + " & [YOUR_CERTAIN_FIELD] & ";this.outerHTML=QBU_Sum'>"


    Replace "YOUR_CERTAIN_FIELD" with whatever field you want summed, then in your report, arrange your fields in the same manner as shown in the URL you posted.

    Here is a snip of the duplicated result:

    Lina, are you just trying to create a running total on a report?  If so you can just use a summary report, break on Record ID# or some other unique record identifier and set the field to be a running total down the column.

    You can put the same field on the report twice, once "regular" and once as a running total.
    Terms & ConditionsAccessibility statement