Generate a "% Complete" tally
Hello, everyone - have recently run into a wall while trying to determine a way to generate a "%" complete. While I originally thought this would be an easy task I've come to realize that my knowled...
Forum Discussion
Ron,
I think the most straightfoward way to handle this would be two Summary fields and a Formula Numeric field. You'll need to add the summary fields to the relationship between Workbook and Records. The first will be a count of related records, and the second will be a count of related records where the status is "Complete".
In your Formula Numeric Field, you'll create a formula like this:
>[# of Records Compete] / [# of Records]
and set the field to display as a percentage. That should give you a % complete result.
If you need more help with it, swing by Data Collaborative's free Office Hours, every Thursday at 1pm Eastern.
Sign up here:
https://data.quickbase.com/db/bqeqqj33i
------------------------------
- Sam
______________________________________________
Sam Jones
Vice President, Product and Technology
he/him
The Data Collaborative, Inc.
sjones@datacollaborative.com
366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
------------------------------
I think the most straightfoward way to handle this would be two Summary fields and a Formula Numeric field. You'll need to add the summary fields to the relationship between Workbook and Records. The first will be a count of related records, and the second will be a count of related records where the status is "Complete".
In your Formula Numeric Field, you'll create a formula like this:
>[# of Records Compete] / [# of Records]
and set the field to display as a percentage. That should give you a % complete result.
If you need more help with it, swing by Data Collaborative's free Office Hours, every Thursday at 1pm Eastern.
Sign up here:
https://data.quickbase.com/db/bqeqqj33i
------------------------------
- Sam
______________________________________________
Sam Jones
Vice President, Product and Technology
he/him
The Data Collaborative, Inc.
sjones@datacollaborative.com
366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
------------------------------
Hi Sam - and thanks for the direction. It worked perfectly!
Looking at my approach, I was obviously off target looking at the Report Formula. Using summary fields and then calculating now makes sense - thanks for helping me learn something today.
First round is on me :)
------------------------------
RONALD KARINSKI
------------------------------
