I want to calculate a net present value (NPV) for a time series data and display it after the grand total. Something similar to Excel. Is this possible?
One way I found to do it was to calculate the NPV for each period and then sum up all the values. However, I still want to be able to display it in the worksheet above or below the grand total.
Also, is there a way to the time series max value, min value, standard deviation above or below the grand total?
Did u find a solution for the above problem. I also want to calculate NPV and Display it in a Single cell.