Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Sales opportunities won after one month, two months, three months etc.

Posted on by Microsoft Employee

Hi

As the title says I would like to report how many of our sales opportunities turn into sales after one month, two monts, three months etc. but I cant figure out how I do this?

Thanks,

Thomas

*This post is locked for comments

  • Verified answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: Sales opportunities won after one month, two months, three months etc.

    Hi Thomas,

     you might probably create a calculated field - there is DiffInMonths function.. If you apply it to modifiedon and createdon (since modified on will be when you closed the the opp), you'll get the number which you can, then, use to build dashboards etc

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales opportunities won after one month, two months, three months etc.

    You can check the difference between the created on date and closed date with status won should be 1,2,3 months. This way you can get how many opps have been won in 1, 2,3 months.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans