1 Reply Latest reply on Jan 30, 2017 5:06 AM by shirin merani

    Display Net Present Value (NPV), Max, Min, Standard Deviation Above Or Below Grand Total

    Joseph Pirraglia

      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?