Forum Discussion
ChayceDuncan
12 months agoQrew Captain
You can do it a couple ways, long and short is you first need to summarize the counts as you've highlighted in (1) and (2).
Option 1 is a 'Master' table - in which you create a single record table known as a master record, and define a relationship where each record is related to this master record, then using summary field count the # of records with each date populated then just do counter 1 / counter 2
Option 2 is to use a summary report and do something like:
- Create 1 field that is formula numeric that is the value of 1 when request date is populated, or 0 if it's not.
- Create another field with the same logic - just based on consent date
You can then take those counter fields and use them in a summary report where you summarize those counter values, then using a summary report formula do counter 1 sum / counter 2 sum
------------------------------
Chayce Duncan
------------------------------