0 Replies Latest reply on Sep 16, 2013 7:53 AM by Robertson das

    NPV Function In Oracle

    Robertson das

      Hi guys

       

      I am using the below code For NPV ,But i dont see any result,could you guys help me out.....

       

       

      DEFINE RPT DIMENSION TEXT

      MAINTAIN TLGT_RPT ADD 'APRV_AMT' 'CAP_APRV_AMT' 'EXP_APRV_AMT'

      DEFINE cflow VARIABLE DECIMAL

       

      declare

      value number;

      begin

       

      value:= @NPV(cflow, .08, RPT_ID);

       

      dbms_output.put_line(value);

       

      end;

       

       

       

      Am i missing any thing Pls rectify.

       

       

      Thanks

       

      Robert