Subtract value from another (new to MYSQL)

Hi,

I am trying to subtract one value from another but do not get the correct outcome.

Below is how I am running the script but it adds the values together instead of subtracting:

• SELECT ID ,(total_1 - total_2) as total FROM Payment Group by 1*

I have tried a couple of different methods I found online without any joy.

Thanks in advance for help.

Probably total_2 already has negative values, which then turns to positive by substracting?

Probably total_2 already has negative values, which then turns to positive by substracting?

Hi,

Correct the total_2 have negative values.

What would be the best way to deal with this?

Thanks for quick response.

Well I guess then total_1 + total_2 should do it, right?