Running Total Using Multiple Columns - Inventory Checker

[OscarGeorge]

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 

[Jean-Balteryx]

Hi @OscarGeorge ,

Do you have any sample data to provide ?

Cheers,

Jean-Baptiste

[Emil_Kos · Accepted solution]

Hi @OscarGeorge,

Please let me know if this was helpful:

[RolandSchubert]

Hi @OscarGeorge ,

Multi Row Formula seems to b a good approach. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland

[atcodedog05 · Accepted solution]

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 : )