Forum Discussion

ChrisFaye1's avatar
ChrisFaye1
Qrew Cadet
5 years ago

Summary Reporting

Is it possible to build a summary report field that does a simple calculation of the values summarized?

Example: I have this information already in a summary because the information is based on dates for each step or quality. 


Summarize -
# of Records:
Then, Records Submitted:
Then, Records Approved:​

I'd like to be able to add an in-report formula field to calculate the percentage of Submitted records that are approved. 
Submitted to Approved Percentage =  (Total Approved / Total Submitted)

So the report would like something like:

                       # of Records       Submitted      Approved      Submitted to Approved Percentage
Team​ 1          400                       200                 100                  50%
Team 2          600                       500                 400                  80%
Team 3          400                       200                 50                    25%

Is this possible?

------------------------------
Chris
------------------------------
  • This is not currently possible.  you would need to have a parent table of Team, and then summarize your record counts up to that Team record for #Submitted and # Approved, then do the division % up there and the report off the Teams table.​​

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------