1 Reply Latest reply on Apr 15, 2016 1:55 PM by diego.medrano

    Add new calculated value to the view based on existing value

    edy hartono

      The thing i try to achieve here is calculate a new value based on existing and all result will be shown in chart, for example :

       

      i have existing data

      month
      value
      110
      215
      310

       

      and then i have to calculated the next month value based on formula AVG(value), the result will be something like

      month
      value
      411.66 //avg(10+15+10)
      511.65 //avg(10+15+10+11.66)
      611.66 //avg(10+15+10+11.66+11.65)

       

      at last i have to display it to the chart (picture below is not the result that i want, still missing month 4th - 12th)

      Capture 1.PNG