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.
- Correct, it will be dependent on how you sort your report, which is fine if you have your report sorted by record id or date created, otherwise, the solution may be harder to do.
I'll reply back if I figure out a good way to have a cumulative field directly tied to the record itself based on record id. - 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.
- hmm, not sure.. you might need to consult with Dan Diebolt and see if he knows how to reverse the order
- FYI,
I have not been able to contact Dan Diebolt in months .... :( - haha, I though that was only me..well, darn
