Calculating Percentage Average of Consent Date Entries: Seeking Formula Assistance

Question

In our data analysis task, we encounter a scenario where we need to determine the average percentage of Consent Date entries compared to Date Requested entries in a table.
The steps are:&nbsp;

Count the total number of entries recorded in the Consent Date field. 
Count the total number of entries recorded in the Date Requested field.&nbsp;
Calculate the ratio of Consent Date entries to Date Requested entries.&nbsp;
Convert the ratio into a percentage average.&nbsp;

All my values are entered into the table, but I don't have the know-how to write the formula.
I imagine it would be a table report generating this percentage. Thank you for your wisdom.------------------------------Ev von Cort------------------------------

chayceduncan · Answer

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).&nbsp;

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:&nbsp;

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------------------------------

Forum Discussion

Calculating Percentage Average of Consent Date Entries: Seeking Formula Assistance