Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 724
  • 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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