4 Replies Latest reply on Mar 3, 2016 11:57 PM by Michael Lang

    Complete Running_Sum when a special value is achieved

    Michael Lang

      Hello,

      I have following problem:

      I have a sheet, which is showing the running_sum of Sales. I have also a Parameter, with whom I can define a Sales amount.

      No I am trying following: Only when the Sales amount selected by the parameter is less then the  Running Sum Sales  Then I wanna see the all Running Sum. If not - nothing.

      I tried a lot of things; but either the running sum starts with the point, where the parameter picks the running sum, or I see always the running sum, also when the sum of the parameter is higher than the maximum value of running sum.

       

      I will attach the workbook.