Calculating Percentage Average of Consent Date Entries: Seeking Formula Assistance

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