Subtracting values of 2 rows and modifying the second row

[Aria_S]

Hi,

I have a simple question. I am trying to subtract 2 rows within the same order and then update the cross-check rows. Below is my input

Orders	Category	Value1	Value2	Value3	Value4
A1234	Total Amount	1000	2000	3000	4000
A1235	Cross-Check	1000	2000	3000	4000
A5678	Total Amount	2000	400	9000	4000
A5679	Cross-Check	1000	100	9000	4000
A2314	Total Amount	3000	600	7000	4000
A2315	Cross-Check	3000	500	6000	4000
A4235	Total Amount	7000	100	2000	4000
A4236	Cross-Check	7000	100	6000	4000

This is what I am trying to achieve,

Orders	Category	Value1	Value2	Value3	Value4
A1234	Total Amount	1000	2000	3000	4000
A1235	Cross-Check	0	0	0	0
A5678	Total Amount	2000	400	9000	4000
A5679	Cross-Check	1000	300	0	0
A2314	Total Amount	3000	600	7000	4000
A2315	Cross-Check	0	100	1000	0
A4235	Total Amount	7000	100	2000	4000
A4236	Cross-Check	0	0	-4000	0

Since there are multiple tiers to this problem, it is getting complicated. Could you suggest a simple way to achieve this?

Thankyou,

Aria

[Emil_Kos]

Hi @Aria_S,

Probably there are more efficient ways of doing but it should work for you:

the output:

[morr-co]

Hi @Aria_S - I've attached a sample of how you could accomplish this with a multi-row formula.

[Greg_Murray]

Hi @Aria_S,

Here is a dynamic example of how to accomplish this.

[atcodedog05]

Hi @Aria_S 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍