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:
Got it. Thank you for your reply. I appreciate your help. One last thing --- in your screenshot, can we have the 458866 be on top and then down to 0? Like a reverse running total.