I want to calculate specific value and want total in the middle

[Sshasnk]

I want to do the total and then place in between and then add another row and subtract it below is the example

Input:

Description	Amount
Buy	123
Sell	156
Purchase	145
Debit	156

Total = Buy + Sell

Difference = Purchase - Total

Output:

Description	Amount
Buy	123
Sell	159
Total	282
Purchase	145
Difference	-137

[Sebastiaandb]

Hi @Sshasnk 

Here you go! See the attached workflow.

Hope it helps

Greetings, 

Seb

[gautiergodard · Accepted solution]

hey @Sshasnk 

See below and attached for one quick way to do it.

[Sebastiaandb]

@gautiergodard  haha seems i made it way more complex than needed haha

[gautiergodard]

@Sshasnk Did this work?

[binuacs]

@Sshasnk One way of doing this is similar to @gautiergodard solution

[KrishnaChithrathil]

@Sshasnk 

If you wanna make things a bit complicated, you can refer this. 😀