Subtracting values of 2 rows and modifying the second row

Arunima_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 @Arunima_S,

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

the output:

Multi rows formula3.yxmd