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!
no chart, I would like to calculate an KPI. But my data is structured like in the example above.
so (20+30+50+50) / (50+60+40+70 = 68,18%