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.
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now


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

Expert Comment

by:Feridun Kadir
ID: 33574484

Author Comment

ID: 33576691

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Watchguard Mobil VPN Client Lan driver could not be installed. 5 2,724
Octets in teradata 3 119
MIS vs ERP 11 309
e-Discovery Software 8 295
If you have problems displaying reports in CRM after a new installation, review the following steps: Check that SQL Server Reporting Services is working On the server that has SQL Server Reporting Services (SQL SRS) installed, check that the S…’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
In a recent question ( here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below.…
Suggested Courses

734 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