• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 721
  • Last Modified:

XIRR calculation in MS Dynamic CRM

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
mayajhon1
Asked:
mayajhon1
  • 3
  • 3
1 Solution
 
Feridun KadirPrincipal ConsultantCommented:
Can you explain what IRR is please and which transaction entity you are talking about?
0
 
mayajhon1Author Commented:
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
 
Feridun KadirPrincipal ConsultantCommented:
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

 
mayajhon1Author Commented:
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
 
mayajhon1Author Commented:
Thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now