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.1559232...
Forum Discussion
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:
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:
Awesome! And is there a way to make the running total by date created? It seems that currently, it is dependent on how the data is sorted. I hope you understand what I mean.