Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I use a past date to specify a future percentage?

Status
Not open for further replies.

elsenorjose

Technical User
Oct 29, 2003
684
US
I didn't really know how to word the subject so here's some more clarification.

I am creating a report which will show me a sales person's conversions for a given date renage based on quotes provided in the past. Here's an example.

Sales person A generated 100 quotes in December. I want to see how many of those quotes resulted in sales within 45 days. How would I create a formula and parameter that would allow me to select the month of the quote (December in this example but it must allow for any month) and specify the number of days in the conversion cycle (45 days in this example but should allow for any length of time)?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top