3 Replies Latest reply: May 17, 2018 9:49 AM by Shivanand Kamath RSS

    Accumulated values

    Markus Blaut

      Dear fellows,

       

      I would like to calculate a KPI.

       

      Example:

       

      I would like to sum up the budget as far as actual sales exist.

       

      There are actual Sales for the month Jan.-April.

      So the calculation would be:

       

      100+50+100+25 = 275

       

      Unfortunately my formula does not work:

       

      If( [Actual Sales] > 0,

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

      ,0)

       

       

      Many thanks for any support!!

       

      Best,

       

      Markus