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

# Rolling Subtraction Calculation

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.