Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoNo 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
CarolMcconnell
5 years agoQrew Captain
Thank you so much, that did the trick.
------------------------------
Carol McConnell
------------------------------
------------------------------
Carol McConnell
------------------------------