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.