6 Replies Latest reply: May 18, 2018 7:32 AM by Markus Blaut RSS

    Accumulated values, KPI

    Markus Blaut

      Hello again,

       

      I would like to compare the accumulated prices of 2018 (Jan - April) with the accumulated price from Jan - April of 2017.

       

      so the calculation would be (20+30+50+50) / (50+60+40+70).

       

      If there exists a price in May 2018, the formula should compare Jan-May 18 with Jan-May 17 and so on...

       

       

      My formula unfortunately does not work

       

      (rangesum(above(sum([Price2018]),0,RowNo())))

       

      /

       

      Sum(Aggr(If(Sum([Price 18]) > 0, Sum([Price 17])),AccountingMonth))

       

       

      Tank you a lot in advance for any help!

       

      Best

      Markus