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.