Summarize # of Records based on Turn around Time

Question

Hello.I'm in need of a report that will count the number of records where the TAT field is less than 15 days and then >= 15 days.This is what I have as of right now and it is correctWhat I'd like it to look like is the two columns but the % of records be in each column, so like this.

State
% less than 15 days
% 15 days or more

New York
95%
5%

------------------------------Carol McConnell------------------------------

MarkShnierYou · Answer

No problem.Make a new formula numeric set to percent format field called [% Less than 15 Days]Make the formula calculate to either 1 (100%) or a 0 based on if the TAT was less than 15 days.Then duplicate the field and call it  [% 15 Days or more] and adjust he formula o be opposite result.Then run a Summary Report and show those two fields as Averages.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community