Solved

XIRR calculation in MS Dynamic CRM

Posted on 2010-08-25
6
706 Views
Last Modified: 2013-11-24
can I calculate the IRR in MS Dynamic CRM.
I have account entity and transaction entity.
is it possible or i need to export to excel.
Thanks,
Maya
0
Comment
Question by:mayajhon1
  • 3
  • 3
6 Comments
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 33528858
Can you explain what IRR is please and which transaction entity you are talking about?
0
 

Author Comment

by:mayajhon1
ID: 33530975
IRR it's an excel formula that will calculate the Internal Rate of return for an investment.
It requires values such as Purchase, sold , and a value of an investment to calculate . I have this information in the db. I just don't know how to apply the fomula and if it's possible.
0
 
LVL 29

Accepted Solution

by:
Feridun Kadir earned 500 total points
ID: 33534483
If the information is stored in the CRM database then it should be possible to do the calculation.

Firstly, where do you want to see the result, on a CRM form? If so, then you will probably need to use a Form event with Javascript to do the calculation and store the result in a field on the CRM form.

Alternatively, you can run a query against filteredviews in the CRM database and do the calculation in Excel

Or maybe you'd like to see the result in a SQL Reporting Services report.
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:mayajhon1
ID: 33536286
I would like to see it in both the crm form and SSRS.
but I'm new to both do you have any suggestion of a book or a site that can help?
Thanks
0
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 33574484
0
 

Author Comment

by:mayajhon1
ID: 33576691
Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
Note: You must have administrative privileges in order to create/edit Roles. Salesforce.com (http://www.salesforce.com/) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales and marke…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question