Discussions

Expand all | Collapse all

Cumulative column without summary report

  • 1.  Cumulative column without summary report

    Posted 11-28-2017 15:07
    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?


  • 2.  RE: Cumulative column without summary report

    Posted 11-28-2017 15:13
    I don�t think that can be done natively.


  • 3.  RE: Cumulative column without summary report

    Posted 11-28-2017 17:56
     

    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.