ChrisFaye1
5 years agoQrew Cadet
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
------------------------------
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
------------------------------