core.noscript.text
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?
Solved! Go to Solution.
if is "out" then change to minus. and groupby TCN and sum it.
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.
@heatherpaquette Similar with above solutions, I also use Multi-Row formula tool.
