Skip to main content
Question

Summary Reporting

  • October 26, 2020
  • 0 replies
  • 17 views

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 topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------