Skip to main content
Question

Cumulative column without summary report

  • November 28, 2017
  • 0 replies
  • 36 views

I need a cumulative column in a report, but I also have fields in the report where I need the user to do data entry within the table.

Is there a way to do a cumulative column without doing a summary report that is read only?
This topic has been closed for replies.

I don�t think that can be done natively.

  • Registered
  • November 28, 2017
 

Don't drink this native kool aide meme.


You can do this using the OEH Technique. (On Error HTML);

Cumulative Sum ~ List All - ASCENDING [Record ID#]
https://haversineconsulting.quickbase.com/db/bnab4bvnx?a=q&qid=1

Cumulative Sum ~ List All - DESCENDING[Record ID#]
https://haversineconsulting.quickbase.com/db/bnab4bvnx?a=q&qid=5

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

Notes:

(1) What the heck is a native solution? Do you in fact mean an Earth Based QuickBase solution? You know QuickBase technology is using in other worlds some of which use more advanced technology and other use less advanced technology. This solution is considered native QuickBase by the inhabitants of the Pugyv4 Colony which have been using their version of QuickBase for 1000 years.

(2) The OEH Technique is described here:

I Just Got Reamed Out By The QuickBase Coordinating Council!!!
!https://community.quickbase.com/quickbase/topics/i-just-got-reamed-out-by-the-quickbase-coordinating...

Are There Any New Pre-Service Worker Disruptive Techniques?
https://community.quickbase.com/quickbase/topics/are-there-any-new-pre-service-worker-disruptive-tec...

(3) Note that the field [Cumulative Sum] will only display the cumulative sum - you cannot use it as an input in to another formula.

(4) [Cumulative Sum] is a text formula field with some HTML allowed. When displaying numeric results the value displays as a left justified text value rather than a right justified numeric value. This of course can be changed using additional markup in the formula definition.