XIRR calculation in MS Dynamic CRM

Posted on 2010-08-25
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.
Question by:mayajhon1
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 29

Expert Comment

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

Author Comment

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.
LVL 29

Accepted Solution

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.
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.


Author Comment

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?

Author Comment

ID: 33576691

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

I showed you how to use console view (HERE ( -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
Read about achieving the basic levels of HRIS security in the workplace.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

728 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