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






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



      Tank you a lot in advance for any help!