Running Total Using Multiple Columns - Inventory Checker

Question

Morning All,

Should be an easy one but can't work it out for the life of me!

I've got three columns "Current Stock" "Inbound Stock" "Outbound Stock"  with a line of data for each day and several hundred products.

I want to sum the three columns on each line to give the netstock and then carry it over to the next day.  Presume I need the multirow formula...

Also baring in mind I need to group by product.

Any help appreciated as always!

Oscar

Emil_Kos · Accepted Answer

Hi @OscarGeorge,

Please let me know if this was helpful:

atcodedog05 · Accepted Answer

Hi @OscarGeorge ,

Here is a workflow for the task.

Here you can select the running total groupby. Yellow highlighted is selected now.

Output (Highlighted is the groupby effect on running total)

Hope this helps : )