Closing Rate % And Filtering
So this is the first time I have not been able to find a solution on other peoples threads, so here is hoping!
Our company gives cash offers for vehicles.
They Submit a Form and Recieve an offer they can accept.
I am trying to get the acceptance rate % for the current month.
So I have it Counting The Submission Dates and Counting the Acceptance Dates to create the Acceptance Rate Percentage.
The problem is I have to sort for the current month. If I sort for submission date this month, I lose the accepted ones that were submitted before the current month. If I sort for acceptance date, it filters it down to only those with an accepted date (Making it think it is 100%).
HOW do i tell it to sort for both dates?
See details attached.
The first image is sorted by submission date - so the Accepted count is off by about 70 but the submission number is correct.
The second image is sorted by accepted date - so now it shows the correct number of accepted (282) but limits the submissions to the same number
This is really messing up the acceptance rate that we need to have!
Please help! Is there a beast mode?