3 Replies Latest reply on Sep 6, 2018 5:41 AM by Zhouyi Zhang

    Rolling Subtraction Calculation

    Tony Ball

      Hi,

       

      Hope everyone is doing good. Had a quick question about subtractions in a calculation.

       

      I have some data where I want to reduce an amount from a total each quarter. In total I have 2277 items and my data has marked each row into 4 different quarters (apart from some null ones)

       

         

       

      I want to achieve the following - subtract Quarter 1 value (158) from the total (2277) which gives me 2119  - I then want to subtract quarter 2 value from the remaining total so 2119 - 1226 which equals 893

       

      I then want to subtract quarter 3 value from remaining total so 893 - 577 which equals 316

       

      finally I then wan to subtract quarter 4 value from remaining total so 316 - 140 = 176

       

      The idea is to produce a stepped bar chart (decreasing each quarter) out of the subtraction calcs.

       

      If this isn't clear or you require a workbook attaching to this mail please let me know.

       

      Thanks for taking the time to read this and as always any help is greatly appreciated.