Total amount per group of data

[Jenina]

Hi All,

Is there an easier way to show the total amount per group of data just below it? And anything below $50/($50) will be commented. The initial way I can think of is via join/union but can't get the exact output. I have attached the sample input and desired output.

Thank you all.

[binuacs]

@Jenina just want to confirm in your attached file is the input and the output are in correct order  or you want the opposite way, I mean the output tab has the actual input data and input has the output data? 

[binuacs]

@Jenina one way of doing this

[Jenina]

@binuacs  hello, the Input tab has the actual input data , output tab is the outcome I want. Thanks

[binuacs]

@Jenina, in that case, if you exclude the Match Id NULL value, you will get the output. Or am I missing something? 

[Jenina]

@binuacs  Sorry, I'm getting parse errors. Looks like it's because the original amounts in my raw file are all absolute, can you please update that? Credit is *-1, debit*1. 

Thanks

[Jenina]

@binuacs  Hi again! Apologies! I swapped the input and output my bad. The input is all -1 match ID. The output is the one that should generate the subtotal. Apologies!

[binuacs · Accepted solution]

@Jenina updated workflow attached

[Jenina]

Thank you @binuacs