Sum Formula

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?

07-2025 Exstars South TMS Non-Reportable.xlsx

Designer Cloud

Accepted answers

Qiu

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

0819-heatherpaquette.yxzp

All comments

AncientPandaman

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

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

0819-heatherpaquette.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703