I have got the following file I am trying to take the difference between each Type for Cost, Interest and MTM. I am not sure how best to accomplish this. RecordIDTypeCost InterestMTM1Type 1125125 2Type 1100100 3Type 2300100504Type 2100100 5Type 3500125756Type 3100100 7Type 41251251008Type 4100100 9Type 5125125 10Type 5100100 I would like it to look something like this. RecordIDTypeCost InterestMTM 1Type 1125125 2Type 1100100 2525 Difference3Type 230010050 4Type 2100100 200050Difference5Type 350012575 6Type 3100100 4002575Difference7Type 4125125100 8Type 4100100 2525100Difference9Type 5125125 10Type 5100100 25250Difference I appreciate the help with this. Thank you!

How to add a row to get a difference between columns of data

I have got the following file I am trying to take the difference between each Type for Cost, Interest and MTM. I am not sure how best to accomplish this.

RecordID	Type	Cost	Interest	MTM
1	Type 1	125	125
2	Type 1	100	100
3	Type 2	300	100	50
4	Type 2	100	100
5	Type 3	500	125	75
6	Type 3	100	100
7	Type 4	125	125	100
8	Type 4	100	100
9	Type 5	125	125
10	Type 5	100	100

I would like it to look something like this.

RecordID	Type	Cost	Interest	MTM
1	Type 1	125	125
2	Type 1	100	100
		25	25		Difference
3	Type 2	300	100	50
4	Type 2	100	100
		200	0	50	Difference
5	Type 3	500	125	75
6	Type 3	100	100
		400	25	75	Difference
7	Type 4	125	125	100
8	Type 4	100	100
		25	25	100	Difference
9	Type 5	125	125
10	Type 5	100	100
		25	25	0	Difference

I appreciate the help with this. Thank you!

Help

Accepted answers

john_miller9

If you need the output to look the same as you posted, this workflow should get you there.

Add Row Get Difference.png Add Row Get Difference2.png

Add Row Get Difference.yxmd

All comments

JosephSerpis

Hi @cfine

if you use a Multi-Row formula you should get the desired results. I've attached my workflow as well.

Multi_Row.yxmd

john_miller9

If you need the output to look the same as you posted, this workflow should get you there.

Add Row Get Difference.png Add Row Get Difference2.png

Add Row Get Difference.yxmd

cfine

This worked great. One more question for you. What formula could I use in Multi Row to achieve the following:

Record ID	Type	Cost	Interest	MTM
1	Type 1	100	25	5
2	Type 1	100	25	10
3	Type 1	100	25	10
4	Type 1	100	25	10
5	Type 1	450	101	50
		250	51	35	Difference	Record ID 5 minus all others

Thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703