EraldoEstrada

7 months agoQrew Member

# Calculating Percentage Average of Consent Date Entries: Seeking Formula Assistance

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:

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

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

------------------------------