Multiple columns subtracting

[Lumjing]

Hi I have been trying to (please see below a sample data) with the output. I have multiple AB,CD columns to subtract and dont want to use formula tool as I have to add multiple formulas for each combination subtraction. I am also not able to use multi field tool as I cannot subtract A and B. is there a better way to achieve this 

A	B	C	D					A	B	AB_Check	C	D	CD_Check
1	2	2	2					1	2	-1	2	2	0
2	3	1	3					2	3	-1	1	3	-2
3	1	4	1					3	1	2	4	1	3
3	4	5	4					3	4	-1	5	4	1

[flying008 · Accepted solution]

Hi, @Lumjing 

FYI.

5- Generate Rows

Condition Expression:

RecordID <= IIF(Mod([Tile_SequenceNum], 2), 1, 2)

6- Multi-Row Formula
Expression:

IIF([RecordID] = 2, [Row-2:Value] - [Row-1:Value], [Value])

7- Multi-Row Formula
Expression:

IIF([RecordID] = 2, [Row-2:Name] + [Row-1:Name] + '_Check', [Name])

Tile_Num2	A	B	AB_Check	C	D	CD_Check
1	1	10	-9	100	1000	-900
2	2	20	-18	200	2000	-1800
3	3	30	-27	300	3000	-2700
4	4	40	-36	400	4000	-3600

[Lumjing]

@flying008  thanks for the quick reply. if possible can you share the workflow here

[flying008]

Hi, @Lumjing 

Just try it by yourself as above process and expression, so easy !

[Lumjing]

@flying008 yes trying to follow but taking time to follow from Generate row tool. Workflow could have helped faster :)

[Lumjing]

@flying008 it worked thanks so much 

[flying008]

Hi, @Lumjing 

Nice done !  👍