NET PRESENT VALUE CALCULATION IN CRYSTAL

I have two years worth of data summarized by month, I am trying to create a field that will give me the net present value of the remaining number of months left.

the report would look as follows

Summary Column      Jan   Feb    Mar    Apr    May ...



It is almost like a crosstab except that I want each column to give me the npv of the remaining columns?

Any ideas
mitaiAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
CR has formulas and financial functions

The financial functions include a NPV function parameters are rate and values.

You will probably have to create a function for each column and supply the correct set of values but it isn't that hard.

The formula will be something like

NPV(rate,[column1, column2, etc])

mlmcc
0
 
mitaiAuthor Commented:
Thanks for the help!
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.

All Courses

From novice to tech pro — start learning today.