Can sum and view negative numbers

[fkeuroglian]

Hello, i want to sum and count negative numbers but i do not know what happend that is imposible to sum and manage with them

i attached a qvd and give example to what happend

thank very much!!

Fernando

[Nicole-Smith · Accepted solution]

=Sum(Num#(TEST1,'###,###;###,###-',',','.'))