Sum Formula

[heatherpaquette]

I am looking to create a formula to show the difference at the TCN level between the in and out.  For example, for T-52-MD-1561 I would like a column that shows the difference between 214,493 minus 142,194 and so on for each TCN.

Could anyone provide a good way to create?

[PangHC]

if is "out" then change to minus. and groupby TCN and sum it.

[KGT]

You can use a sort, then Multi-row formula grouping by TCN (and probably month).

Otherwise, you can crosstab the data using In/Out as the header, then create a column that calculates the difference.

Depending what you want to do next, as to which method suits better.

[Qiu · Accepted solution]

@heatherpaquette 
Similar with above solutions, I also use Multi-Row formula tool.