Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Dynamics 365: Using date field to calculate % of budget

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

We are trying to figure out how to calculate current sales as a % of budget amount.  Fiscal year starts on 4/1 not 1/1 so we need to determine sales in Jan/Feb/Mar back to previous year 4/1.  Any suggestions on how to best code this for [% of budget] field?

Thank you in advance for guidance, two non IT guys trying to make Dynamics 365 work for our company.

*This post is locked for comments

  • Suggested answer
    M I Mostafa Profile Picture
    M I Mostafa 4,257 on at
    RE: Dynamics 365: Using date field to calculate % of budget

    I think to do this properly, you should consider a Dynamics 365 plugin. I don't think a calculated field can do this for you.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans