1 Reply Latest reply: Aug 5, 2016 7:27 AM by Sunny Talwar RSS

    Last 5 days values in staright table with date

    Naveen N

        How to calculate the last 5 days vNAV% values using date in straight table  

      FUND_IDFUND_NAMECAPITAL_FLOW_TRANSACTION_DATEvNAV%
      989Fidel28-07-20160.1
      992Uniges28-07-20160
      989Fidel27-07-20161.8
      989Fidel26-07-20160.7
      992Uniges27-07-20160
      989Fidel25-07-20164.8
      992Uniges26-07-20160
      992Uniges25-07-20160
      992Uniges24-07-20160
      989Fideli24-07-2016100001
      989Fidel22-07-20160
      989Fidel23-07-20161.2
      992Uniges23-07-20160
      989Fidel21-07-20163
      992Uniges22-07-20160
      992Unigest21-07-20160