7 Replies Latest reply: Sep 4, 2018 10:38 AM by Markus Blaut RSS

    Accumulated Values

    Markus Blaut

      Dear fellows,

       

      I would like to calculate a KPI (growth). Example: I would like to sum up the pieces for 2017 as far as pieces for 2018 exist and compare them.

       

      So in Fiscal Year 2018 there are pieces from accounting month 201710 until accounting month 201807 (yellow),

      so I would like to compare them with pieces from Fiscal Year 2017 from accounting month 201610 until 201707 (green).

       

      The yellow numbers should be Sum({<FiscalYear = {2018}>}  [Pieces])

       

      but I don't get the green formular.

       

      Any idea how I could manage that with a formular?

       

      Many thanks for any support!! Best, Markus