summing negative values in separate column

[CB308]

Hello

How can I realize this logic/formula?

If I have a total of two separate columns and the value is negative (see Position-stock), how do I show only the negative values in a separate column and able to total all negatives?  Currently my total is zero instead of  5493405.

Thank you in advance!!!!

Totals	Ending Position	Stock	Position-Stock	Negative Totals as Positive
Totals	25453598	23003823	2449775	0
PLine1	19591501	20736596	-1145095	1145095
Pline2	8995999	13344309	-4348310	4348310

[CB308]

that did help... i'll let you know the results and thank you for your time.  It is appreciated.

[CB308]

thank you for all the answers, still having an issue, but using the same data, how would I calculate lets use "Ending Postion" percent to total of the "Ending Position" column?

Currently my calculation for Ending Position is column(1) + column(3), + column(5) onwards.

=num(sum(("Ending Position") ) / sum (Total ("Ending Position") is obviously not correct, need help please.