1 Reply Latest reply: Apr 4, 2017 6:39 AM by Vineeth Pujari RSS

    Make data date wise

    gaurav gopale

      Hi

       

      I have the following table

       

       

      Budget:

      load * inline

      [

      Plant,Month ,Value,Year

      P1,Jan,100,2016

      P1,Feb,100,2016

      P1,Mar,100,2016

      P1,Apr,100,2016

      P1,May,100,2016

      P1,Jun,100,2016

      P1,Jul,100,2016

      P1,Aug,100,2016

      P1,Sep,100,2016

      P1,Oct,100,2016

      P1,Nov,100,2016

      P1,Dec,100,2016

      ];

       

      the above budget table by month

       

      I want to make it day wise data i.e i have sum up the Value and divide by 365 (sum(Value)/365) and group  by Plant