5 Replies Latest reply: Mar 20, 2015 6:51 AM by Matthias Herkommer RSS

    Using accumulation in expressions

      I have got a list of items sold at a certain price and volume (#units), resulting in the corresponding revenue (price * units, see e.g. first table).


      Now I would like to calculate the price level where the accumulated revenue (running total) is at least 20% of the total revenue. (which is “price = 9” in the example, see second table). I need this value for further visualizations.


      At the moment I am struggling to calculate the accumulated revenue and use it inside an expression (formula).

       

      table3.jpgtable4.jpg